Ok...that's still not getting me what I'm looking for. Here's what I need:
I need the totals for orders placed within a date range. Regardless of whether or not they've been invoiced in, or out of, that date range.
I thought I could take the total from orders that haven't been invoiced (SOP10100), and add that to the total from orders that have been invoiced (SOP30200). That doesn't seem to be working. I'm using the ORDRDATE field to filter both tables. Apparently this isn't correct as my totals are not adding up to what the client shows they should be.
Can anyone think of a reason for this? Am I pulling the data incorrectly?
Thanks in advance!