Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cmcdonald
  • Content: Threads
  • Order by date
  1. cmcdonald

    Parameter query using 'OR'

    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...
  2. cmcdonald

    Entering multiple parameters

    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...
  3. cmcdonald

    Converting data stored numerically to Words in a report

    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...
  4. cmcdonald

    Ignoring the time part of date format.

    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

Part and Inventory Search

Back
Top