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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query by form problems

Status
Not open for further replies.

spurs100

Technical User
Jun 5, 2002
20
GB
Hello,

I have a query that takes its parameters from a form, however i am having trouble with one of the fields. I am tring to limit the records by using expressions i.e less than (<) then a number in the form field but i keep getting an error message saying the expression is too complex, if i put this expression in the criteria box in the Query by Grid field it works fine.

hope i have expalined my problem well!!!!!!!!!!

Please help!!!!

thanks in advance
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top