Originally Posted by
June7
Enter a new rate where? If you don't want to change existing records, options are:
1. save the rate to data records using code (VBA or macro)
2. save rate record ID to data and when a new rate is needed, create a new rate record, have a field that flags the older rate record as 'Inactive' or use date/time field to show date started. Use criteria in query to exclude "Inactive" or use date of data record compared to date of rate started to determine which rate to associate with data.
Option 1 is probably the simplest approach.