SarahNorth
New member
- Local time
- Today, 12:22
- Joined
- Apr 11, 2019
- Messages
- 7
I have created a report that has averages for some groupings. I then use DLookup to retrive marks assaigned to those specific averages from another table. The correct result only shows for the last record on the report. It is as if the result from =Avg() is calculated after the field with the DLookup function executes. If I use a field withouth a calculation to test my DLookup function everything works out fine.
How can I force one calculation to be completed before another or how to I get Access to execute the DLookup function after a second or even put that code behind a button.
I want to use the average in the report to look up the primary key in another table and then return what is in the field corresponding to that ID into a text field.
Help please
How can I force one calculation to be completed before another or how to I get Access to execute the DLookup function after a second or even put that code behind a button.
I want to use the average in the report to look up the primary key in another table and then return what is in the field corresponding to that ID into a text field.
Help please