Vista Forums
Vista Forums Home Join Vista Forums Donate Vista Tutorials Tags

Welcome to Vista Forums we are your forum to discuss Windows Vista x64 and x86 systems. Whether you need help or just want to post an idea you have on Vista, this is the forum for you.
Register at Vista forums...the world biggest Windows Vista resource Join Vista Forums Now

Go Back   Vista Forums > Vista technology newsgroups > WinFX General

Access 2000

Closed Thread
 
Thread Tools Display Modes
Old 08-20-2007   #1 (permalink)
lulunix77
Guest
 
Posts: n/a

Access 2000

Hi,

I am using Access 2000 and having a bit of a mental block,

I have my database feeding into excel and need to group by my month setting.
I is cuurently grouping by date.

i.e 01/04/07 - Apr 07

I need it to group by APR 07 and not 01/04/07, I know this can be done but
can not remember wether it needs to be in Access or in the Pivot table, this
is currently driving me mad, I have tried all the normal functions and even
creating a new date table etc, it's probably something really simply

Thanks in advance
--
lulunix :-)
 

Closed Thread

Thread Tools
Display Modes









Vistax64.com is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media 2005-2008

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46