Here are 4 expressions that are in two different queries. One query works perfectly. When the other query is run a popup box displays saying Category I - enter parameter value. I cant seem to figure out why. I took the database that was working perfectly, copied and pasted it and gave the query a new name. I created a button so it would perform the exact same scenarios of the other query. For some reason I STILL got the enter parameter value. Why on earth with a duplicate query with a different name display that when the other one works perfectly (the changing of the query name should have nothing to do with it because i changed the name of the query to run on the button i created. Here are the 4 expressions that are in question. The first two are from the query that works properly.
Due Date: (IIf([Category I]=True,[Sent to Field]+20,[Sent to Field]+30))
Expr1: IIf([Category I]=True,[Sent to Field]+20,[Sent to Field]+30)
The two above expressions are in two different fields within the query. Now for the two pieces of code from the other query that are in question and make the 'enter parameter value' box display. Yes, I know that 'sent to field' is changed to 'Date of Action'.
Due Date: (IIf([Category I]=True,[Date of Action]+20,[Date of Action]+30))
Expr1: IIf([Category I]=True,[Date of Action]+20,[Date of Action]+30)
What in the heck is the difference in these pieces of code???!!!!
Due Date: (IIf([Category I]=True,[Sent to Field]+20,[Sent to Field]+30))
Expr1: IIf([Category I]=True,[Sent to Field]+20,[Sent to Field]+30)
The two above expressions are in two different fields within the query. Now for the two pieces of code from the other query that are in question and make the 'enter parameter value' box display. Yes, I know that 'sent to field' is changed to 'Date of Action'.
Due Date: (IIf([Category I]=True,[Date of Action]+20,[Date of Action]+30))
Expr1: IIf([Category I]=True,[Date of Action]+20,[Date of Action]+30)
What in the heck is the difference in these pieces of code???!!!!