Report from Query, 4 views

[FJB]

I need to create a report from one query, but the information needs to
be massaged differently for four ways. Where do I start? If I was
working in Excel, it woul dnot be a problem.

Thanks for your help

Frank

 

[Rick Brandt]

I need to create a report from one query, but the information needs to
be massaged differently for four ways. Where do I start? If I was
working in Excel, it woul dnot be a problem.

First define "massaged".

 

[Larry Linson]

First define "massaged".

Then explain "differently, how?"

I'm not sure what this means, nor why it is important.

Is it a "problem" because you don't know Access as well as you know Excel,
and, thus, aren't sure where to start; or, have you determined, or are just
guessing, that it is difficult or impossible to accomplish what you need to
do in Access?

An Excel spreadsheet can have a different meaning for each cell, and a
different calculation; if that is what you need, then Excel might very well
be better suited for your task than Access. On the other hand, if you have
record after record that each needs to be manipulated the same (and your
statement that you are "creating a report from one query" implies that may
be the case) then there's a very good chance that Access may be well-suited
to what you want to do.

Larry Linson
Microsoft Access MVP

 

[FJB]

Thanks for your replies and help. I apologize for not replying earlier.
Let me see if I can explain my problem better.

The setting is a doctor's office. I have a database which tracks the
number of patients, their diagnosis, which doctor sees the patient, as
well as the charges. The report in question would allow me to pull a
report for a specified period of time to show the total number of
patients served, the number of patients served by each doctor, the
number of patients by diagnosis, and the charges by doctor and
diagnosis.

Thanks again. Let me know if you have further questions.