Recent content by dce719

I have set up an Inventories Database and need help creating a report that will display the total inventories in the storeroom, as well as, each restaurant and bar. I would like to create the report from my queries. There is a separate query for the storeroom, as well as,for each restaurant...

My apologies Chris. I didn't mean to accuse you of "hard core" programming. This inventory date will change at the end of each calendar month. Thanks again.

Thank you Chris. This is the date of a physical inventory that will never change. Creating a table with the date is a good idea, and what do you mean by making it hard core? Once again, Thank you.

Can someone please me to set a fixed date on a form. e.g. January 31, 2004. to appear on form whenever the form is open. Will the same formula work on a report? Any help is appreciated.

Thanks for your help.

I need help designing a report that will show the "Grand Total" from different queries all on one page. I have tried several times to create one in design view or with the wizard but after selecting the source information from the 1st query a new report design or wizard opens up for the next...

Thank you. I'll set this up and test it.

I am new to Access and is currently working on an inventory database. I have tables such a Pricelist, Vendor, Outlet Name. There are ten queries for each Outlet selected from Outlet Name table. Each qry Outlet has a list of no less than 80 records that include ProductID, ProductName...