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!

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

No query output when array empty

Status
Not open for further replies.

ZOR

Technical User
Joined
Jan 30, 2002
Messages
2,963
Location
GB
Is there a way to make this query work if arrays srtList1 and srtList2 are empty. At present I am evauating each to see if one/both/none are filled and then having 4 queries instead of just one. Thanks

& "AND TXCLIPS.Shot IN (" & Mid(strList2, 2) & ")" _
& "AND TXCLIPS.StarRating IN (" & Mid(strList3, 2) & ")" _
 
As far as I recall, you are building this in code, so why not test the contents of the list and just leave the line out if it does not contain an item. Alternatively, check the listcount property and do not process if it is zero.
 
Many thanks Remou. Yes it's in code so I will continue to evaluate and leave line/lines out as required. Regards
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top