abomb Posted July 18, 2006 Posted July 18, 2006 Hello everyone, I swear I've seen this topic before but can't seem to find it now. If someone could point out a post or help me I would appreciate it. I have four tables, Customer Quote Quote Item Job Quote Item has both a QuoteID and JobID. A job are items that were quoted that need to be processed. This so far has worked well. I can print a quote report for all items and then if it is a job, I can print anther report to process it. What I'm can't seem to do is sum total Customer orders. I want to track a "capture" rate on Customer table. How many actual dollars am I getting from quoted dollars. I'd like to do this for each customer. I can sum Quoted dollars easily from an extended total field on Quote Item, but can't seem to sum only records that have a JobId. Thanks for any help.
Recommended Posts
This topic is 6765 days old. Please don't post here. Open a new topic instead.
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