I've got two forms (Golfers and Sponsors) based on two tables (also Golfers and Sponsors). Tables are linked via GolferID field.
There is an unbound text box on the Golfers form that I'd like to use to show the total amount pledged for each golfer. I've created a Sum Query that's working, but can't get the Total Pledged to populate the unbound text box - just get the #Name? error.
I know this should be simple, but can't wrap my head around it this afternoon - Help!
There is an unbound text box on the Golfers form that I'd like to use to show the total amount pledged for each golfer. I've created a Sum Query that's working, but can't get the Total Pledged to populate the unbound text box - just get the #Name? error.
I know this should be simple, but can't wrap my head around it this afternoon - Help!