Aggregate Report Dates

[Brennan]

Hello:

I have a report in an Access 2000 database that looks at
potential sales for a number of project managers and then
does some calculations. The report pulls from an query
where potential sales are rolled up into a sum by Project
Manager. I now have to make the following changes to the
report.

The report should look at the current date and then go
back 3 years and break the potential sales totals out by
the year the sales process was originated (We do track
this date in the database).

A project Manager can bid on the same job for several
different General Contractors. When ever that happens, I
need to take the lowest bid to do my calculations.

I have tried using DateDiff to handle the date issue but
have not been successful.

Any suggestions would be appreciated

Thanks
Brennan

 

[Jeff Boyce]

Brennan

If your query doesn't include the date originated, add it. In your report,
you can GroupBy year of the date.

Finding the lowest (i.e., minimum) bid per project manager sounds like a
Totals query, but we'd have to get an idea of how your data is organized
before we could make reasonable suggestions.

Good luck

Jeff Boyce
<Access MVP>