Teresa Allen
New member
- Local time
- Today, 22:27
- Joined
- Mar 5, 2003
- Messages
- 8
This is my first message,
I have a form where I calcuate a field containing minutes multiplied by a target speed (another table) based on a product.
(downtime.Minutes * product.target speed)
pretty simple the relationship between the two tables is the product, but now they want to increase the target speed in the product table but still want to calculate minutes prior to the increase date using the older target speed. I know this is probably so simple but I can't seem to figure out what fields I need to add to the product table and the calcuation I need to use on the form. I'm sure there will be future speed changes.
Thx
I have a form where I calcuate a field containing minutes multiplied by a target speed (another table) based on a product.
(downtime.Minutes * product.target speed)
pretty simple the relationship between the two tables is the product, but now they want to increase the target speed in the product table but still want to calculate minutes prior to the increase date using the older target speed. I know this is probably so simple but I can't seem to figure out what fields I need to add to the product table and the calcuation I need to use on the form. I'm sure there will be future speed changes.
Thx
