Claymationator
Well-known Member
- Joined
- Sep 26, 2006
- Messages
- 705
I looked through the forum but wasn't able to find anything for the question that I have...
I have a database that I created that contains customer information for multiple orders. The table that I have has the customer information (Name, address, phone, etc) and then information for up to 5 orders (date, time, comments, what was ordered, quantity, etc).
The form that I have created to enter in the information has a total of 6 tabs (one for customer info, and one tab for each of the 5 orders). I am trying to run a query that will return information for all of the 5 orders at once. Some that I have tried is to find out what brand of product was ordered within a certain week, how many orders were placed overall within a certain week, among others. When I do this I can get Access to return the query if I do it for only one of the orders, but when I try and apply the same criteria to the other orders at the same time it returns nothing.
Can anyone help me with this? If you need more information please let me know and I can go into more detail.
I have a database that I created that contains customer information for multiple orders. The table that I have has the customer information (Name, address, phone, etc) and then information for up to 5 orders (date, time, comments, what was ordered, quantity, etc).
The form that I have created to enter in the information has a total of 6 tabs (one for customer info, and one tab for each of the 5 orders). I am trying to run a query that will return information for all of the 5 orders at once. Some that I have tried is to find out what brand of product was ordered within a certain week, how many orders were placed overall within a certain week, among others. When I do this I can get Access to return the query if I do it for only one of the orders, but when I try and apply the same criteria to the other orders at the same time it returns nothing.
Can anyone help me with this? If you need more information please let me know and I can go into more detail.