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
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