I feel really stupid. The query is working just fine. I didn't scroll down far enough. I have a lot of part numbers in my inventory without any quantity on hand. I've added criteria now that eliminates parts without quantities.
I hope your day has gone better than mine has started. Thanks for waking me up!
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :
Posted by: firstname.lastname@example.org
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (3)|