Question about user-entered parameters in queries

[rootdown42]

I have an update query in Access that requires the user to enter a
parameter to define the fiscal quarter, which is assigned to the
FSC_QTR field. Within the same query I am attempting to use the
FSC_QTR field to lookup a value from another table and assign it to
the QTR_NUM field. However, I am not getting any results when I first
run the update query in the QTR_NUM field. However, if I run the query
again, I do get results, leading me to believe Access is executing the
lookup before prompting the user for the parameter value (even though
I put the FSC_QTR field to the left of the QTR_NUM field). What I want
to know is if there is a way to correct this so that the user can
enter the parameter value and that value is used to lookup another
value, all in the same query, or do I just have to perform the lookup
as a seperate step afterwards.

Thanks

 

[Allen Browne]

Switch the query to SQL View (View menu, in query design.)
Post the SQL statement here.