Date format in query

[mauricionava]

Hello, I need to make a report for a list of dealers displaying how many cars they have sold each month for certian year. How can I make it to show me only the month and year and how many cars per dealer?

I know it's something like (Format[FieldName] and then how you want it formatted as

thanks.

 

[PHV]

Sorry but the cristal bowl is in vacation today and I'm tired to play the mind reader character.
From which data would you run such aggregate query ?

FYI, boled word is a good candidate as keyword search.

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

 

[VRoscioli]

Try Format([FieldName],"mm/yyyy"), etc.

-V