Sorry for the lame thread title...I don't really know what else to call this issue.
I have a database table that contains many date fields with the combination of 'Letter' and 'Number' as the key. Here are my field names:
Letter
Number
Ship Date
Induction Date
Test Start Date
End Date Return Date
Test Finish Date
Actual Turn-Around Time
For each record, I am trying to calculate what the actual turn-around time would be based on a formula for the 'Letter' & 'Number' combination found in another table. Here is the formula table:
For a record in the 1st table where 'Letter' = A and 'Number' = 1, is there a way in a query to calculate the Actual Turn-Around Time as End Date minus Ship Date?
I hope this makes sense. This is the best example I could think of