Total of page Q 1

[stillwillyboy]

I looked thru the past posts and saw a few q's that related to this, but still I couldn't get it to work. I must be missing something very simple.

In a table I have Quantity and Price. In a query for info in this table I have: ExtendedAmount = Quantity * Price.
It calc's properly.

I have a report tied to the query. I have in my detail section of the report the above three fields. There may be more than one line of information. The info shows properly in the detail section.

I want the grand total to appear in the page footer. In the control source of a text box I have: =sum([ExtendedAmount])

I keep getting Error. What am I missing?

TIA.

 

[dhookom]

I have no idea what you mean by "path to the db" since I never mentioned anything about a path or external file.

You said you have a table of Orders. I assumed that one or more orders would be included in a single Invoice. For instance, in a month, CompanyA places 3 orders which contain multiple order detail records. My earlier suggestion was to place an InvoiceNumber field in the Orders table. Assuming we create InvoiceNumber 444 which is stored in the InvoiceNumber field of 3 different Orders from CompanyA. My suggestion was to create a table of invoices that would store the InvoiceNumber as well as some other fields about the invoice.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[stillwillyboy]

So I would know the invoice numbers while I was entering the orders?

 

[dhookom]

StillWillyBoy,
You would have a table of Invoices with one record for each past invoice
tblInvoices
=============
InvoiceNumber PrimaryKey
InvoiceDate
InvoiceComments

You have a table of Orders for all orders
tblOrders
==============
OrderID
OrderDate
...
InvoiceNumber

You would select the orders to invoice and add a new record to the invoice table with the next InvoiceNumber, the date, etc. Use the new InvoiceNumber value to update the InvoiceNumber in the records in the tblOrders that you want to invoice. Once you have the new Invoice record in tblInvoices and the Order records updated, run an invoice report of the new invoice and include the Orders and Order details.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.