Hello,



So I have a data access page based on a table. It works fine. What I would like to know how to do is add a textbox to each record that calculates a value for that record. However, that value comes from another table. I do have a unique identifier. I just don't know how to go about creating this field.

I did set up a parameter query that works but don't know how to make that work in the data access page.

Sample data.

a sample row in the data access page.

ID=1
Name=Apple

Textfield= amount of times ID 1 was sold in the last 30 days.

The amount is from another table. Again, I do have a saved query for this.

Any help would be appreciated. Thanks.