Grouping by a field

[slinger24]

Is it possible to take information from a table and group the information into one record?

I have a table that looks like this:

[Dealer] [Date]
San Diego Jan
San Diego Feb
Sacramento Jan
Bakersfiel Jan
Bakersfiel Feb
Bakersfiel Mar

I would like to group the above table like this.

[Dealer] [EXPR1] [EXPR2] [EXPR3]
San Diego Jan Feb
Sacramento Jan
Bakersfiel Jan Feb Mar

 

[PHV]

Have you tried to follow the CrossTab query wizard ?

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

 

[slinger24]

Thank you for the reply.

Never thought of that! I will try it.

Thank you.