Selected Query results to seperate Fields...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hoping someone can help. I have a medical Database table that show the order
we are to bill people. I need to be able to view results or somehow extract
them so I can view them in 2 seperate fields for a report.

eg The table looks like such:
Name Current Order Garantor
Sally 1 Medical
Sally 2 Self Pay
Greg 1 Sutter
Greg 2 Medical

I need to be able to view the information in a report like this:
Name Garantor1 Garantor2
Sally Medical Self Pay
Greg Sutter Medical

I hope this makes sence. I have come to this problem a few times and haven't
worked out a way to do it yet.
 
Take a look at crosstab queries. Your name field is the row heading,
"Garantor" & [Current Order] is the column heading, and First Of Garantor is
the Value.
 
You should try the cross tab query

TRANSFORM Last(Mediacl.Garantor) AS LastGarantor
SELECT Mediacl.Name
FROM Mediacl
GROUP BY Mediacl.Name
PIVOT Mediacl.Current_Order
 
Back
Top