I have a form that uses text boxes with code and a query in the form.
This was easier for me since Im not good at making complex calculations in query's.
The problem I had before was using the IIF statment with Between AND. Which I thank all the expert for there help and time.
Now I have come into a delima.
My query is over 1000 characters!! It was suggested that I use a Function. Which Im not familar with. And dont know how to incorparate it with how I have the form done now.
Help experts!
Please talk to me as simple as you can so that I can get it. Enclosed is the form that has the query in the form that calculates, and the summary with text boxes that have calculations in it also.
Again thanks for time and help!!!!!
HelpWithQuery--2-.zip
I don't think 1000 characters or even 2000 is going to hinder you, except that it makes it harder to make changes, find errors in typing the SQL.
It looks like you went away from the BETWEEN/AND statement in the query, and are expecting a range to be determined using the '-'.
So, IIf([Production]=343-346
evaluates to Iff(production = -3
and so on.
Am i reading this correctly?