I need some guidance as how to best approach my form. I have two tables (example only)...
Table1 has a record for each hour of the day (Date, Hour,Factor)*Note: there is a factor for every hour
Table2 has random records which need to be matched with Table1 and calculations made (Date,Hour,Qty)
For every Hour in Table1 i make this calculation: Factor*Qty=ORCalc (The last qty gets carried to the next hour until there is a change in qty).
This is all good to this point. Now I want to display this data a couple of different ways.
1. By hour (this I sort of have using a continuous form but I need to do it into a subform)
2. Total ORCalc By Day and then totalled by month (Should I dump the "by hour" into a temporary table before so it can be refiltered?)
if YES to #2... how do i create this temporary table?
many thanks
diane
Table1 has a record for each hour of the day (Date, Hour,Factor)*Note: there is a factor for every hour
Table2 has random records which need to be matched with Table1 and calculations made (Date,Hour,Qty)
For every Hour in Table1 i make this calculation: Factor*Qty=ORCalc (The last qty gets carried to the next hour until there is a change in qty).
This is all good to this point. Now I want to display this data a couple of different ways.
1. By hour (this I sort of have using a continuous form but I need to do it into a subform)
2. Total ORCalc By Day and then totalled by month (Should I dump the "by hour" into a temporary table before so it can be refiltered?)
if YES to #2... how do i create this temporary table?
many thanks
diane
