Hi have a requirement to use MS Access to store (in separate tables) cost data, and in separate tables, proportional allocation (values less than 1) so that I can do a multiplication in a query to multiply Cost x Allocation = Proportional Cost.
The Cost numbers are ok - I can use Currency or...