Unbound textbox to display total sales of 1 customer

[KLahvic01]

I have an unbound textbox that I want to have populate the total amount in sales for one customer on the customers information page. I tried building a query and calling the result with a DLookup command and it worked for the total, but when I changed from one customer to the next it carried the same total over. I would like it to just total up sales based on the customer ID.

I hope this makes sense.

Thank you,

KJ

 

[pbaldy]

I'd use a DSum() with the appropriate criteria:

http://www.mvps.org/access/general/gen0018.htm

 

[KLahvic01]

I will try that. One question though, I am unsure how to call the sum based on the Customer ID, I guess what I am asking is how do I write that criteria in?

 

[pbaldy]

Did you follow the link? You'd want the form example.