Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Grid 1

Status
Not open for further replies.
ZOR

ZOR

Technical User
Jan 30, 2002
2,963
GB
Am I using the correct syntax placed in a query grid to display all records found against the srring array of strList1

Symtax in query grid criteria produces no records

In (" & Mid(strList1, 2) & ")

Thanks

 
Sort by date Sort by votes
No, as the query builder doesn't know what strList1 is.
I think you have have to build the whole SQL in VBA.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Many thanks PHV. I thought I would put the question on this site as well as my last post. I had spent hours trying all permutaions, referencing around. Now I know the fact I can move on. Thanks again, have a star.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
Query expression negative to a 0
Replies
6
Views
653
dhookom
dhookom
mhshane
  • Question
Is this the best way to do this query? 1
Replies
9
Views
403
mhshane
mhshane
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
1K
strongm
strongm
C
  • Locked
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
539
OzFoxy
OzFoxy
breezett93
  • Question
Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less
Replies
8
Views
666
breezett93
breezett93

Part and Inventory Search

Sponsor

Back
Top