Use a percentage for calculations on a form

[nigelbloomy]

I have one table that hold a percentage. The table is only one record and one field. That percentage is updated throughout the month.



I have my main table which shows a lot of other numbers. I have a form linked to this main table so users can enter values and change values. On that form, it is very helpful for the users to see a few calculations which use the percentage on the other table. My problem is that my form won't let me use the percentage in any calculations because it it is not linked to the main table. I tried to base the form off a query that did do the calculations, but the resulting query cannot be edited or changed by the user because the two tables are not linked. I don't think the tables can be linked because the main table has a lot of data and the percentage table has just one thing on it. How can I make this form work?

[rzw0wr]

Try a Dlookup() function.
=Dlookup("[PercentField]","TableName")
use this where you would use the Precent field name.

If the table only holds 1 field the the WHERE clause is not needed.

Dale

[nigelbloomy]

It works! That was way too easy. Thank you for restoring my sanity for the day.

[rzw0wr]

My pleasure.

Dale