Calculation in Accwss between 2 tables

[RAK]

When I have a access program with 4 tables and want a certain answer based on the date within a table how do you do the calculation taking one value from entry and checking that value against another table?

 

[WP]

RAK,

Do you mean the user enters a date and you want to check it against a date stored in a table ?

Is it a one record table ? How do you get to the record ?



Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out my website !

 

[RAK]

1. Enter into entry form.
2. From date entered I want to go to another table for the specific date which is a table full of dates pre plugged in.
3. The table has like 10, 15, 30 days for due dates.