DATE FUNCTIONS

A

angie

i have a crosstab query combining fields from multiple tables.
i have a field containing expiration dates (medium date format) e.g. 05/06/2004.
i want the crosstab query to calculate how many cards expire each month, e.g. june-2004. how can i achieve that?
 
J

John Spencer (MVP)

Try grouping by
Format([ExpirationDate],"yyyy-mm")

You will need to drop the Expiration Date field from the crosstab since it will
force a record for each date.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table 0
Crosstab with subquery as source to another query 5
VALIDATION RULE 1
How to have two tables on same line? 1
Copy previous record into form field 0
Conditional Formatting Training Expiry Dates 2
Date Brackets as an IIf statement 3
Taking the sum between two dates 2

Top