Where do I make formulas

[Guest]

Hello Its me again
Here is what I need
I need to have an inventory form or table that will have around 20-30
thousand entires in it.
This will need to calculate inventory on hand - sold which = the balance
then I need to have another form or table I am calling this one the monthly
report
that will take the gross - comm = net
and theotherformula i it will have
rate times gross = comm.
I do not know how or where I need to make these at can some one help me in
detail on what i need to do..
just to let each of you in on this
I have a tumor on the brain which causes my comperhension to slow down
so this is why reading a book isn't helping me any I need steops any help
would be greatful thank you
Tammy

 

[Scott McDaniel]

If you need a Report, you can do these either directly in the report's
Recordsource (the query), or you can put them in as the .ControlSource of
textboxes and such on your report. How you actually do the calculations
depends on how your tables are setup, but in general Inventory On Hand is
((StartingCount + Purchases) - Sales) ... of course Sales could also include
gifts, giveaways, warranties, etc ... Purchases could include
StockPurchases, returns, etc etc ..

The Northwinds sample db that ships with Access may have some similar items
.... perhaps you could review these reports and see if something is similar.

 

[Guest]

Hello Tammy ...

Inventorty control can be very difficult to understand ...
The QtyOnHand value should be calculated "on the fly" when needed ...
Here is a link to information that will help you understand the needed
structure and how to do it ...

http://allenbrowne.com/AppInventory.html

R. Hicks