Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2007

Tip: Looking for answers? Try searching our database.

Price X quantity

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Charlie - 30 May 2007 20:33 GMT
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.
Signature

Charlie

RBear3 - 30 May 2007 21:05 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.