P
Pauline
How can I run a query (or two) against 2 different data ranges for the same
report?
IE: I need 1 column to reflect a current date range ie Jan 8-14. I have
a Make Table Query for date ranges that creates and DSUMs my totals for the
first week, and I used an unbound text box to capture the start and end date
criteria from the query to display on the report.
But I need a second column as well with the previous weeks totals ie Jan
1-7. Do I have to force the user to run a second Make Table Query and
manually enter the previous week's date ranges? Or is there a way combine
the Make Table Query into a single query with 1 date range and automatically
subtract 7 days from the dates entered to calculate a second set of figures
to be DSUMmed as well.
THEN, I need to take the difference between the newest DSUM value and the
previous week's DSUM value to calculate the percentage difference. The
end result is so simple, but automating as much of the process as possible
for the end user is a learning experience.
Thanks,
report?
IE: I need 1 column to reflect a current date range ie Jan 8-14. I have
a Make Table Query for date ranges that creates and DSUMs my totals for the
first week, and I used an unbound text box to capture the start and end date
criteria from the query to display on the report.
But I need a second column as well with the previous weeks totals ie Jan
1-7. Do I have to force the user to run a second Make Table Query and
manually enter the previous week's date ranges? Or is there a way combine
the Make Table Query into a single query with 1 date range and automatically
subtract 7 days from the dates entered to calculate a second set of figures
to be DSUMmed as well.
THEN, I need to take the difference between the newest DSUM value and the
previous week's DSUM value to calculate the percentage difference. The
end result is so simple, but automating as much of the process as possible
for the end user is a learning experience.
Thanks,