Inventory Beginning Balance First line on a form in Datasheet View

[ssalem]

Hi,

I have a form I have displaying in Datasheet View that refers to a query pulled by parameters of start and end date. What I need is to have all the inventory totaled to display as the first record. In short they use to keep the inventory on a spreadsheet. Even though I have moved this into a database they would like to view they way they use to see it in a spreadsheet. They would have beginning inventory every month at the top and all the transactions for the month below it. I did a report that functions this way by using DSum for the beginning total based on the parameter of the start date. But now I have a form view as a datasheet. I can dsum but instead of being the first row it shows up at the end of the form.

The only way I can think of to get around this is to create a database the same as mine. Empty the contents. Run 2 queries from the parameters given. Load the beginning inventory query to the database then load the second query to the database...then display the database in a datasheet view.

Question is there an easier way....if not.....can I combine 2 queries and display that in the form instead? I am not really sure how to pull the data from the queries into the database if I have to go that route.



Any guidance how i should tackle this would help.

Thanks

[burrina]

Why can't you have an unbound field and set it's source to the calculated field?