I cant get my query results to list in the text boxes! (1 Viewer)

[Officeboy]

I've made a simple database and I've made a cross tab query to show some statistical results. In my front page, I have where the results are going to show. I simply thought if I associate the control source to those fields, it would work. After I found out that didn't, I'm trying to create a Dlook up for this.


Can you check my code and see if you can see what i'm doing wrong?

Thank you guys!
View attachment Per Lead Tracking Database.accdb

 

[Trevor G]

I've made a simple database and I've made a cross tab query to show some statistical results. In my front page, I have where the results are going to show. I simply thought if I associate the control source to those fields, it would work. After I found out that didn't, I'm trying to create a Dlook up for this.


Can you check my code and see if you can see what i'm doing wrong?

Thank you guys!
View attachment 33464

What you need is in the subform place in an extra textbox in the form footer and name it like txtTot1 and then use the control source to sum the charges.

Then on the main form place in another textbox and use the control source to find the subform txttot1 and you will get a result of 50 on your first record. You can also use avg and count.

Hope this helps you.

Example returned.

 

[Officeboy]

Thanks! It works!