Calculating totals for Invoices

  • Thread starter Thread starter Jan Il
  • Start date Start date
J

Jan Il

Hi all - Access 2K - WinME

I have a quick yes or no question. I have a table that lists the items in a
purchase to be used to create an invoice. The PO number will, of course, be
set for no duplicates. As there can be more than one item ordered, this
means I will need to make provisions for multiple items in the invoice.

I don't want to hard store the totals, but have them calculated only when
the invoice is called up, by query, or control. My first thought is to
create a subform to take care of this task, but, I've not done this type of
form before, and am not sure, and I just want to make sure that my thinking
on this is correct before I go there, or, if there is a better way to
accomplish this task.

I would truly appreciate any suggestions or references on this subject.

Very best regards,

Jan :)
 
Jan Il said:
Hi all - Access 2K - WinME

I have a quick yes or no question. I have a table that lists the items in a
purchase to be used to create an invoice. The PO number will, of course, be
set for no duplicates. As there can be more than one item ordered, this
means I will need to make provisions for multiple items in the invoice.

I don't want to hard store the totals, but have them calculated only when
the invoice is called up, by query, or control. My first thought is to
create a subform to take care of this task, but, I've not done this type of
form before, and am not sure, and I just want to make sure that my thinking
on this is correct before I go there, or, if there is a better way to
accomplish this task.
Click to expand...
Yes.
The Northwind database has example.
 
Back
Top