Reports or Query?

  • Thread starter iaqsuk via AccessMonster.com
  • Start date
I

iaqsuk via AccessMonster.com

I have a Extension list I want to create by department and by clinic:

500 Front Desk - Clinic A
501 Lab Desk - Clinic A
502 X-Ray Desk - Clinic A

600 Front Desk - Clinic B
601 Lab Desk - Clinic B
602 X-Ray Desk - Clinic B

700 Front Desk - Clinic C
701 Lab Desk - Clinic C
702 X-Ray Desk - Clinic C

I Have no problem creating a database for this, but it's the Report or Query
is my question. The current database prints reports like above. My question
is: Did I need to do a Query or set up the Report? to make the report look
like this:

Clinic A
500 Front Desk
501 etc
502 etc

Clinic B
600 Front Desk
601 etc
602 etc

Clinic C
700 Front Desk
701 etc
702 etc

Is this possible? Please Help. Thank you. Arnol
 
J

John Spencer

Assuming that you have the Clinics in a separate field then you should
be able to build a report that groups on Clinic and prints the details
of the extensions in each clinic

You can base the report on a query (or the table if you want all the
records).

In the report you would select Sorting and Grouping from the view menu.
In the first row select Clinic and then check group header.
In the next row click extension and sort by it (no group)

Close the window.

In the group section put the Clinic
In the detail section put the extension and the desk.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
I

iaqsuk via AccessMonster.com

Thank you for your help, that worked. Arnold

John said:
Assuming that you have the Clinics in a separate field then you should
be able to build a report that groups on Clinic and prints the details
of the extensions in each clinic

You can base the report on a query (or the table if you want all the
records).

In the report you would select Sorting and Grouping from the view menu.
In the first row select Clinic and then check group header.
In the next row click extension and sort by it (no group)

Close the window.

In the group section put the Clinic
In the detail section put the extension and the desk.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
I have a Extension list I want to create by department and by clinic:
[quoted text clipped - 31 lines]
Is this possible? Please Help. Thank you. Arnol
 
K

KARL DEWEY

Use Sorting and Grouping and select Clinic as group. Put Clinic in the group
header.
 
I

iaqsuk via AccessMonster.com

Thank you everyone. Your suggestions has been really helpful and it worked.
Thanks again. Arnold

KARL said:
Use Sorting and Grouping and select Clinic as group. Put Clinic in the group
header.
I have a Extension list I want to create by department and by clinic:
[quoted text clipped - 31 lines]
Is this possible? Please Help. Thank you. Arnol
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top