Display query criteria into another query

[dudumomo]

Hello everyone,

I'm using a combo Access/Excel to do some calculation (Access) and some advanced report (Excel).

To have the result of one query, the user need to enter the number of the month.

However to better follow the evolution month after month, I want to keep record in Excel of the results.

Hence I would like the user to export the result + add the flag of the month. (Then, it will be very easy with a pivot table to follow month by month)

But it is not convenient to let the user manually add the flag whereas he has already fulfill the criteria coming from another query.

Do we have any possibility to display the criteria into the result of the quiery (NOT A FORM !) for pivot table usage.



Hope I'm clear...

Thank you for your help

[Robeen]

It is not easy to understand what you need.

Is this what you want:

1. The user will enter the month number for which he wants to see data - right?
Q. Is the user entering the month number in a Form - or is he running the query itself?
Q. If the user is entering the month number to view results for a particular month - how is the query able to find records for that month?
Can't that same date field that is being used to return a certain month's data - also be used in Excel for the pivot table?
Why do you need to add the month from the criteria that the user entered when it is already in the record source?

2. Once the user enters the month and views the data - you want the data exported to a spreadsheet with the month number added to a new field in the query results.
Q. Does the user NEED to view the data?
Q. If the user does NOT need to view the data - is it always a specific month's data that the user needs to see [Eg: Previous Month]?
If it is always something predictable - like previous month - the whole process can be automated.

Let us know.