Need help: 1 form 2 tables = no DATA

voidcranium

Registered Something.
Local time
Today, 12:37
Joined
Oct 29, 2006
Messages
175
I have a form that all information on it is based on one table.
I need to use a number from another table to do some calculations to populate a text box on this form.

Example:
FORM BEING USED
TABLEONE
field_#Up
field_# inPack

TABLETWO
field_Sheets_per_min

I need on my form a text box to calculate the price per pack.
((# in Pack/ # Up)/ Sheets per min)

I would also like to populate a text box with that information showing what the
value being used is.
ie: Sheets per Min: 55

*******************************

I have searched and found that I might need to use the Dlookup but am really lost on how to use it.

Thanks for your help.
 
You usually do not store calculated fields. So you would have an unbound text box to display your calculation. Record source being the calculation.
Having said that... there are times when calculations DO need stored... But you'll need more then one field in your table 2 to do so... Perhaps an ID#... Date and time... then SheetPerMin.
 

Users who are viewing this thread

Back
Top Bottom