Re: query design issue

I appreciate the help. I actually am not sure this will help. I am doing
this in a table, not a report. I have to export out to excel once it is
completed for another department.
--
Buck


"Duane Hookom" wrote:

Create a main report of just each unique Provider (no members). Then create
a multi-column subreport that is based on the Provider and Member records.
Set the subreport to display across then down. Add the subreport to the
detail section of the main report and set the Link Master/Child properties
to Provider.

--
Duane Hookom
MS Access MVP

"buckpeace" <buckpeace@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:15C64180-1FAA-4EE3-A762-4DB2592368B1@xxxxxxxxxxxxxxxx
Hopefully, someone can help me with the design of the way a table looks
from
a query.

Lets say I have a table that has 10 rows of member and providerinformation
in it. However, there are ONLY 5 doctors. Some of the doctors have more
than 1 patient, so they have more lines. IE -
PROVIDER MEMBER
dr. jones mary
dr. jones james
dr. jones sam
dr. adams eddie
dr. jay amy
dr. jay sally
dr. peace jake
dr. steph kenny

What I need to do is produce a report with only 5 total lines (equal to
the
amount of doctors) with colums for each member.....IE
PROVIDER MEMBER1 MEMBER2 MEMBER3
jones mary james sam
adams eddie (blank) (blank)
jay amy sally
(blank)
peace jake (blank)
(blank)
steph kenny (blank)
(blank)


Can anyone help me write a query for this procedure.....I must have the
columns as each member must stay int he same line as the provider they
use.


I really appreciate it!!!!




--
Buck



.

Relevant Pages

  • Re: query design issue
    ... I thought you were asking for a report when you stated "What I need to do is ... a multi-column subreport that is based on the Provider and Member ... there are ONLY 5 doctors. ...
    (microsoft.public.access.queries)
  • Re: query design issue
    ... Create a main report of just each unique Provider. ... a multi-column subreport that is based on the Provider and Member records. ... Set the subreport to display across then down. ...
    (microsoft.public.access.queries)
  • Re: query design issue
    ... Sorry about the confusion with the word "report". ... etc.)with people in them....in that same tabe, a doc with one member may only ... a multi-column subreport that is based on the Provider and Member ... there are ONLY 5 doctors. ...
    (microsoft.public.access.queries)
  • Re: KNOWN *DELIBERATE* MISTAKES* FRAUD, $$$$ A OK, SHHHHHH
    ... we have to have a law creating a national databse on alternative ... >> report errors to safety organizations which can analyze trends and create ... >> revenue and/or reputation especially with respect to hospitals or other ... only a small percentage of the worst doctors have their licenses ...
    (misc.health.alternative)
  • License To Kill Is A OK Within Conventional Medicine
    ... report errors to safety organizations which can analyze trends and create ... The President stated that " by providing doctors with information about what ... practice medicine. ... hospitals in the United States including working actively to prevent medical ...
    (misc.health.alternative)
Loading