Our inventory table calculates a current balance and our inventory transaction table shows all transactions by date but no balance. I have rearranged the transaction table to provide a period end date and activity summed by period. I have also included an date Index column and created duplicates of the Index and period columns to self reference. What I am trying to get now is a balance by period but I cant find a way to make this work yet. My query includes the following columns,
[Index] [Index_B] [END_DATE] [END_DATE_B] [PART] [PERIOD ACTIVITY]
I am looking for a way to sum [PERIOD ACTIVITY] by [PART] where [END_DATE] <= [END_DATE_B]
or
sum [PERIOD ACTIVITY] by [PART] where [Index] <= [Index_B]
Any help is greatly appreciated
[Index] [Index_B] [END_DATE] [END_DATE_B] [PART] [PERIOD ACTIVITY]
I am looking for a way to sum [PERIOD ACTIVITY] by [PART] where [END_DATE] <= [END_DATE_B]
or
sum [PERIOD ACTIVITY] by [PART] where [Index] <= [Index_B]
Any help is greatly appreciated