Balance of Inventory and details for specified date range after that date.

[ssalem]

Not quite sure how to do this. I need to have a summary of everything on the database in inventory up to the date range inputed on the input form. Then everything for the date range specified I need the details of transactions. The database itself is all transactions for inventory. Im not quite sure how to get this. If I run a query summary for the date ranges I will not be able to get my Beginning Inventory before those dates. \

Im thinking I need to use the whole database but not sure how to sum on my unbound text boxes for between date ranges. Thinking I have to do this all in VB code and not even use a query. Creating a loop to sum all the variables to populate beginning inventory.

Help.....I am old school programming and not to fluent in VB but probably could manage. I am an old FoxPro programmer. Just don't want to be doing alot of VB coding if there is an easier way.

Thanks

[pbaldy]

I doubt you need code. You can use a DSum() with the start date in the criteria to get the beginning balance. Sum the date range on the report for that total. Add them together for the overall total.