Derived Field

G

Garret

I'd like to add a derived field to this situation:

Parent Table : Shipments
(pk)Shipment_No
Shipment_Date
Shipment_Size
....other fields...

Child Table : Shipment_Inspection
Shipment_No (connected field)
Number_Out_Tolerance (bad ones in the shipment)
....other fields...

I'd like to make a derived field "der_percent_good" that takes the
shipment size that the inspection belongs to and does
(1 - Number_Out_Tolerance/Shipment_Size)*100 to find the percent of
the shipment that is Good.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Derived Field 0
Derived Field 0
A Derived Field 8
Copy previous record into form field 0
How to Make Access do the work 5
Help setting up relationship 21
summing 2 different totals in a continuous form 2
Issues with Rounding (or lack thereof) 1

Top