category - sum

[xxyy]

Dear All,

I'd like to solve the following problem.

I have a table similar to this:

material1_date1_qty1
material1_date2_qty2
...
material1_date9_qty9
...
materialN_dateX_qtyW

I'd like to define categories for date (e.g. month) and summarize the quantities:

material1_period1_qty1+2 (if date1&2 are in period1)
material1_period2_qty3+4+...+9 (if date3-9 are in period2)
...

I cannot give conditions/categories in function 'sum' - how can I solve this?

Please help!

BR
xxyy

 

[MStef]

Look at "DemoCategSumA2002.mdb" (attachment).
Open Query1.

 

[xxyy]

Dear MStef,

Your solution is quite simple, thank you!

BR
xxyy

 

[xxyy]

Dear All,

How can I use week instead of month? There's no 'week' built-in function (there's 'month' function)

thx

xxyy