View Single Post
  #6 (permalink)  
Old March 30th, 2005, 05:12 PM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

What happens when you drop all the ( and ) in the WHERE statement?

Then use Response.Write to write out the SQL statement and run it in the query analyzer of Access. What do you get?

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Brand New You're Retro by Tricky (Track 8 from the album: Maxinquaye) What's This?
Reply With Quote