DATE FUNCTIONS

's Computer Specifications

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?

's Computer Specifications

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.

angie wrote:
>
> 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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using date functions to automatically advance the date on a form	Jch461	Microsoft Access Form Coding	3	28th May 2008 04:05 PM
Re: Date Functions	Arvi Laanemets	Microsoft Excel Worksheet Functions	0	3rd Jan 2007 05:19 PM
Re: Help On Date Functions	Mary Chipman	Microsoft Dot NET	0	15th Sep 2004 02:53 PM
date functions	JOE	Microsoft Access VBA Modules	4	6th Sep 2003 04:30 PM
date functions	franky	Microsoft Access VBA Modules	2	4th Jul 2003 03:38 AM