Help Tracking Hairdye

[Adam]

I am working on a database for a cosmetologist friend of mine and I'm trying
to track hair dye inventory, and then subsequently be able to run a report to
generate a shopping list of what dyes she has used and needs to buy. I've
created a table and a form that have the dye's color line, level and tone, as
well as the units in stock, reorder level, and reorder quantity. I can get
the reorder quantity to generate in the form with a subtraction expression
but can't figure out how to get it to generate in the table then eventually
onto the report. I also can't figure out how to only print the hair dye
table records that actually have a reorder quantity, I can only figure out a
report with every dye whether or not more is needed.

Any ideas will be appreciated!

 

[Lynn Trapp]

Adam,
You don't need to store the reorder quantity in your table. You can
recalculate on a report it in the same way that you do on your form. Also,
to get your report to work the way you want simply base it on a query that
has your reorder calculation as one of the criteria.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Adam]

Lynn,

Thank you so much for your guidance, it all makes perfect sense now!

Adam

 

[Lynn Trapp]

Adam,
I'm glad you got it worked out.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html