 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / July 2006Comparison
Hope someone can help me on this, I have been asked to create a report that will compare a product's sales to it's returns. Each product has it's key "Text" ProductCode, plus the Return for that product also has it's own product code. In the inventory list these 2 codes are not always above or below each other so the between parameter wouldnt work, if it would have worked anyways.... Any suggestions? Can you provide an example with real (or imaginary) data, and what you'd want to have show up? Regards Jeff Boyce Microsoft Office/Access MVP > Hope someone can help me on this, I have been asked to create a report > that will compare a product's sales to it's returns. Each product has it's > key "Text" ProductCode, plus the Return for that product also has it's own > product code. In the inventory list these 2 codes are not always above or > below each other so the between parameter wouldnt work, if it would have > worked anyways.... Any suggestions? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.