Change in Column based on base query column

rave

New member
Local time
Today, 11:04
Joined
Mar 21, 2013
Messages
6
hi, i need help!

while my tille is confusing.. let me try to explain what am i trying to do here...

i have created a cross tab to extract pipeline and sales for Q1 2014, Q2 2014, Q3 2014 & Q4 2014... the user can select the quater from a multivalued text box...

Now for the final output, have created another query which pull the above four quarter in each column from the cross tab...now the problem arises when i change the quarter to Q2 2014, Q3 2014, Q4 2014 & Q1 2014..it gives an error "Microsoft office Access database does not recognizes "Query name" as a valid field name or expression".

The error is because the second layer of query does not identifies Q1 2014.

How do i make access change the column automatically when the Q1 changes to Q2...
 
if you post the sql to both your queries, someone might be able to help
 

Users who are viewing this thread

Back
Top Bottom