DATE FUNCTIONS

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

Guest

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?
 
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.
 
Back
Top