Thread: query problem
View Single Post
  #2 (permalink)  
Old September 8th, 2003, 04:00 AM
ioates ioates is offline
Authorized User
 
Join Date: Jun 2003
Location: Manchester, , United Kingdom.
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Have you tried a space between either side of the ampersand?

rs.Open "SELECT contractno,recordno,category,contractor FROM arc where contractno='" & contractno & "'",cn,1,2

Regards
Ian
Reply With Quote