B
buckpeace
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!!!!
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!!!!