Data extract needed, use macro?

[Rebecca]

I need to write a quick data extract.
It involves joing two tables and also doing some grouping
and summing.
It needs to accept a parameter for from date and to date.
'From date' must be a Sunday and 'to date' a Saturday.
Then it needs to join the 2 tables.
The resulting view will contain a date field.
My data extract will need to sum the hours for each date
in a Sun-Sat week and make the total a column. However,
many weeks the from/to range spans will determine how
many 'week columns' are returned.
My manager wants this yesterday.
Is the easiest way to do this to write a macro which calls
a routine?
Any tips welcomed.

 

[Steve Schapel]

Rebecca,

No. This is not a job for a macro. The easiest way is to use a Query
to define the data set you require. It sounds like a crosstab query
would be the applicable method.

Sorry to hear about your mananger.

- Steve Schapel, Microsoft Access MVP