S
Sarah0824
I have a parameter query that I run to pull certain dates (ie - 3/1/08 -
3/31/08) and the name of the event that happened in that date range. The end
result that I want to get is a report that lists these dates (which is easy)
and also same events for the prior month and prior year.
I have tried to create a 2nd query that will pull the event name from the
parameter query, but I am stuck at how to make it look for only those that
are the prior month or prior year. I think the parameter is what is
confusing me because that changes each time the query is run.
If I could get a 2nd query or even a third one, I know I can join them
together and create my report, but I'm stuck in the middle.
Any help is very much appreciated!
3/31/08) and the name of the event that happened in that date range. The end
result that I want to get is a report that lists these dates (which is easy)
and also same events for the prior month and prior year.
I have tried to create a 2nd query that will pull the event name from the
parameter query, but I am stuck at how to make it look for only those that
are the prior month or prior year. I think the parameter is what is
confusing me because that changes each time the query is run.
If I could get a 2nd query or even a third one, I know I can join them
together and create my report, but I'm stuck in the middle.
Any help is very much appreciated!