Search results for query: *

The problem with using a combo/list box is that the list of possible parameters is derived from a table of Order Numbers, which, as such, is large and dynamic. Cara

I am trying to run a parameter query which prompts for input, but I want to be able to enter more than one criteria separated by 'Or' and with no limit on the number of criteria. It was suggested to me that I might try a looping sequence to achieve this, but, try as I might, I cannot figure out...

Here you go: SELECT POrder.POrder_RaisedDate, POrder.POrder_No, Cust.Cust_Ref, Products.Product_Code FROM (Products INNER JOIN (Trans INNER JOIN (SOrder INNER JOIN Cust ON SOrder.SOrder_CustID = Cust.Cust_ID) ON Trans.Trans_SOrderID = SOrder.SOrder_ID) ON Products.Product_ID =...

Help! Sounds much more complex than I'd anticipated, and possibly than I need. The query runs fine if I enter multiple criteria as part of the design. I thought there might be a simple solution to the parameter prompt problem. Lets try the first part of your suggestion? Cara

I'm not sure how much more detail I can provide, so I will try and make the question clearer. I have: [Enter Order Number] as the parameter. If the user enters one number, they will get the record(s) corresponding to that number. I want them to be able to enter more than one number at a time...

I have a query which prompts for an order no. each time it is run. However, I need it to return values for more than one parameter. I thought that I could enter , eg, '1524 or 1511' in the pop up box, but this returns an error message. I get the same message when I use commas to separate the...

Thanks! I feel silly for not working this out, but at least it's done now. Cheers, Cara

I have a table of customer orders whose order status is stored in a table as one of six or seven different numbers, each representing a different status. ie: 20 = Ready, 30=Pending, 40=Complete, etc. I am unable to change the way they are stored in the table, but I would like to display the...

I can't seem to get the syntax right with the parameter to add a day. Could you give me a hand?<br><br>Cara

Yeah, I found that out the hard way. I guess I was hoping there was a way around it. :)<br><br>Thanks

I am trying to write a parameter query to retrieve records between two dates. The date format in the table is dd:mm:yy hh:mm:ss (and I cannot change this).<br><br>How do I write the query so that the users need only enter the dd:mm:yy part of the dates they wish to query between?<br><br>Cara