I am looking to create a single query for the following:
I would like to capture a list of all products and their descriptions with ytd total, previous month, current month, and projected for next month.
All information is held in the same view as follows:
Product
ProductDescription
DisburseDate
This is how I would do it.
SQL Code:
You said you wanted totals, I assumed you had to have a Qty field.
Please Login or Register to view this content.
Hope this helps,
Dan
"I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
If my advice has been helpful to you, then please help me by clicking on the "Star" and adding to my reputation, Thanks!
I do not have a quantity field, all entries are listed seperately on a per order basis.
K so remove [Qty] and place a 1 in there.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks