Select Query

[paulS30berks]

I wondered if someone could help

I am querying a table using a select query. The data I am pulling from the table is in format:


Period Year Value

0 2006 1000
1 2006 100000
2 2006 500
3 2006 5000
4 2006 50000
5 2006 200000


In my query, I wish to seperate:

Period 0 + value

from

Periods 1-5 which should be cumulative.

Thanks

Paul

 

[MStef]

Hello Paul!

Look at "DemoSelQueryA2000.mdb",
open Query2.

 

[paulS30berks]

Many thanks for your reply, much appreciated.

I do need to seperate period 0 from the other months. i.e

period 0 - value
period 1-5 - value

Thanks

 

[paulS30berks]

I am looking at writing a statement such as:

Expr1: Sum(IIf([period]<=[forms]![fixed asset register]![period] And Not ([period])=0,[value]))

but no results show