Access Querry

I have Table that has fields Such as
Date,Item#, SubCode#,ToDay'sQty, UoToDateQty. I have Records For # days.
Jan 21 1 2 500 500
jan 22 1 3 100 100
jan 23 1 2 300 800 What Querry Should I
wright so I get Exactely Like above Table? I need to get UpToDateQty for
Item #1 and SubCode#2 on Jan 23 To be 800.

Thanks

Andy

Looks like you are trying to store a calculated value in your table. You
seem to be creating a running total and storing it. That violates
normalized database design.

Instead, store all the data you listed (except the current Qty) and
calculate it when you need it.

--
Rick B



"Andy" wrote in message
...
I have Table that has fields Such as
Date,Item#, SubCode#,ToDay'sQty, UoToDateQty. I have Records For # days.
Jan 21 1 2 500 500
jan 22 1 3 100 100
jan 23 1 2 300 800 What Querry Should I
wright so I get Exactely Like above Table? I need to get UpToDateQty for
Item #1 and SubCode#2 on Jan 23 To be 800.

Thanks

Andy

Thanks Rick B

Running Total doesn't work. it make Total of All Items And SubCode .

My requirement is to find sum Of all Todays Qty on privioud date and add it
to ToDaysDate Qty and that total should return in UpToDateQty Field
For Each Item3 and SubCode#

"Rick B" wrote:

Looks like you are trying to store a calculated value in your table. You
seem to be creating a running total and storing it. That violates
normalized database design.

Instead, store all the data you listed (except the current Qty) and
calculate it when you need it.

--
Rick B



"Andy" wrote in message
...
I have Table that has fields Such as
Date,Item#, SubCode#,ToDay'sQty, UoToDateQty. I have Records For # days.
Jan 21 1 2 500 500
jan 22 1 3 100 100
jan 23 1 2 300 800 What Querry Should I
wright so I get Exactely Like above Table? I need to get UpToDateQty for
Item #1 and SubCode#2 on Jan 23 To be 800.

Thanks

Andy

"Andy" wrote:

I have Table that has fields Such as Except UpToDateQty Field
Date,Item#, SubCode#,ToDay'sQty, UoToDateQty. I have Records For # days.
Jan 21 1 2 500 500
jan 22 1 3 100 100
jan 23 1 2 300 800 What Querry Should I
wright so I get Exactely Like above Table? I need to get UpToDateQty for
Each Item #1 and SubCode#2 as shown above( on Jan 23 To be 800. See 100 is not added)
UpToDateQty is calculated field and I need to see my report look like
above Table

Thanks

Andy