Need help running a query

[Claymationator]

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.

 

[giacomo]

is your default view set to Datasheet? if so change it to either single or continuous forms

hth,
Giacomo

 

[Claymationator]

I am not sure I follow. I am still new to this, so how would I change from continuous to single or vice versa.

 

[giacomo]

it's in the form properties, set the default view property to either single or continuous form...

hth,
Giacomo

 

[Claymationator]

Thanks for the tip...it worked beautifully. Next time I won't be so slow to understand. Keep it up.