Question about user-entered parameters in queries

R

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
 
A

Allen Browne

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top