JTSmith Posted August 13, 2012 Posted August 13, 2012 I have a table of Customers, and a table of Jobs. Some customers have 1 job, and others have 100+. I have a field called Customer Worth, and I'd like to show on each customer record the total they have spent in the past. I don't need it to be year to date or anything, just a running total. If I use the Sum function, I think it only shows current jobs... Thanks...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now