Nested query of sorts?

[lawrencep]

I have a group of equipment from which monthly data is collected. I'd
like to be able to produce a running 12-month report that displays the
data collected. The crosstabs and transforms all summarize the
data--I'd like to display the actual results. Equipment by rows and
dates in the colums. Any suggestions on how to proceed?

Thanks,

Patrick

[Larry Linson]

Without any description of the data you have, and how you keep it in tables,
I can only say this shouldn't be all that difficult.

You can calculate the criteria using Date or Now to choose the end month for
your report, use the DateAdd function with -12, months, to calcuate the
start month, and pick up the appropriate information by date.

Post back here with clarification about the tables and the data you are
keeping if you want to discuss details of how you report the "raw" data.

Larry Linson
Microsoft Access MVP
"lawrencep" <la*******@ivc-pdm.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

I have a group of equipment from which monthly data is collected. I'd
like to be able to produce a running 12-month report that displays the
data collected. The crosstabs and transforms all summarize the
data--I'd like to display the actual results. Equipment by rows and
dates in the colums. Any suggestions on how to proceed?

Thanks,

Patrick

[lawrencep]

The table is basically set up as EquipmentName, SurveyDate, Status
(text, date and interger). To make it interesting, some equipment may
have more than one entry per month (test/retest/retest again) or no
test at all (tested quarterly or maybe it wasn't running).

I'd like it to look like:

EquipName Mar04 Apr04 ... Mar05
Pump1 1 1 3
Pump2 3 2 2

Thanks,

Patrick