Can this be done automatically?

[Danu]

I have a small report that I run weekly, four tables, six queries. The user
would now like to see not only this week's data, but the previous week(s)
data as well and be able to build on the report each week.

Can this be done in Access or would it be better to export the current
week's data to an Excel spreadsheet?

Can someone point me in the right direction?

Thanks.

 

[Allen Browne]

Since you want to present 2 groupings in the same query, you will need to
use a subquery to get the total for the previous week.

Here's the general idea of how to cover two different periods in one query:
http://allenbrowne.com/subquery-01.html#YTD
Change the dates in the subquery so it shows the previous week instead of
the year to date.

 

[Duane Hookom]

We don't know how your query/report filters by week but it shouldn't be
difficult to include a wider date range. I don't have a clue what you mean by
"build on the report".

 

[libbeyc]

I have a small report that I run weekly, four tables, six queries. The user
would now like to see not only this week's data, but the previous week(s)
data as well and be able to build on the report each week.

Can this be done in Access or would it be better to export the current
week's data to an Excel spreadsheet?

Can someone point me in the right direction?

Thanks.

What kind of a report is it? Text, Charts, combination, something else?

Chuck --

 

[Danu]

Sorry. In my head I know what I mean but that doesn't mean everyone else
does...

As each week progresses, he wants to see the current week's data and all
previous weeks data as well.

Does that help any?

 

[Danu]

Thank you! I will take a look and see if I can apply it to this report.

 

[Danu]

It is numbers for four different categories. The user would like to see this
week's numbers for the categories but as each week progresses, he wants to
see the current week as well as previous weeks. So the previous week's
figures would be static but the current week's figures would be dynamic?