Madawc you figured out exactly what I needed thank you very much. I feel bad that I did not figure that one out on my own. It is amazing what one forgets when the boss wants it done yesterday. Thanks again everyone.
John
First of all, thank you very much for your prompt and correct answer yesterday. I do still have one issue. I have found a summary function that is distinct count, that gives me the correct count of the records. However, I am also using a sum() that is of course giving me incorrect results...
Here is my situation:
I have 2 tables joined on the customer ID. I want to display information from both tables. The problem I have is if the customer has more than 1 order they are displayed twice. What I would like to do is display the customer information with the appropriate order...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.