This is probably fairly simple, but I don't quite get it. I have a form that
acts as an invoice. There is a field for price. I'd like to add a field for
quantity and have that calculation display in an extended price field, which
is where my totals will be calculated from.
Are you going to save the quantity? Are you going to save the price (since
it may change over time) so that you will always know the total for the
particular invoice?
I would recommend you take a look at the Northwind sample database that
comes with Access. It includes a form for invoices. Creating and storing
an invoice is pretty complex. You typically store the invoice record in one
table, then store the related invoice detail lines in a separate table. You
also have the issue of using the current price for an item, being able to
give discounts, etc. And of course there is tax, payment methods, normal
addresses vs. shipping addresses, etc.
All of those issues are handled in the Northwind sample.
Once you take a look at it, post back with specific questions and we can
help you out.
______________________________________________________________
If you don't want to do that, the simply answer to your question is that you
would create a new textbox on your form and put something like....
=[myQuantityFieldName] * [myPriceFieldName]

Signature
Hope that helps!
RBear3
.
> This is probably fairly simple, but I don't quite get it. I have a form
> that
[quoted text clipped - 3 lines]
> which
> is where my totals will be calculated from.