J.P.,

thanks for feedback.

Instead of something like:

PRODUCTS SALES ORDERDATE
Cheese 123 3/3/2009
Cheese 456 3/12/2009
Milk....
etc.

I would like to aggregate (group) the single dates to months:

PRODUCTS SALES ORDERDATE
Cheese 579 March 2009
Milk....
etc.

Is there any way to have Microsoft Query doing that ?

Thank you in advance.

hgl








"JP" wrote in message
...
Excel version?

Can you give an example of what the output would look like?

--JP


On Feb 2, 7:00 am, "H.G. Lamy" wrote:
Hello,

is it possible to aggregate lots of daily billing dates to 12 months in
Microsoft Query, before returning the data to Excel?
Thank you in advance.

Kind regards,

H.G. Lamy