Calculate field titles 1

[djthul]

Is there a way to use a formula to change the field titles? I have a query that summarizes vendor performance data by month:

Vendor Month Percent Count
Vendor1 200901 100% 180
Vendor2 200901 85% 220
Vendor1 200902 95% 350
Vendor2 200902 75% 200

I would like a summary query to look like:

Vendor 200901Perc 200901Count 200902Perc 200902Count
Vendor1 100% 180 95% 350
Vendor2 85% 220 75% 200

If it matters, I'm using Access 2003

Thanks for your help!

 

[PHV]

You may consider a CrossTab query:
faq701-4524

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[djthul]

That looks great, thanks for your help!