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 Rhinorhino 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: *

  1. JaysinM

    Parameter Queries that query more than one field

    I got part of it fixed and it works alright when I have it checking only the first 2 fields (Food1 & Food2) but when i added on Food3 and Food4 Im getting errors again.  Any ideas?  Would it be because Food3 and Food4 are blank in all the records right now or something and if...
  2. JaysinM

    Parameter Queries that query more than one field

    SELECT [Father's Business Database].SSN, [Father's Business Database].[First Name], [Father's Business Database].[Last Name], [Father's Business Database].Food1, [Father's Business Database].Food2, [Father's Business Database].Food3, [Father's Business Database].Food4, [Father's Business...
  3. JaysinM

    Parameter Queries that query more than one field

    Ive never used any SQL so I quite honestly cant say Im too familiar with what you're talking about hehehe. sorry.<br><br>Jaysin
  4. JaysinM

    Parameter Queries that query more than one field

    Ive tried doing that and it just gives me an error stating that the expression was too complex....any other ways I can accomplish this or any suggestions??
  5. JaysinM

    Parameter Queries that query more than one field

    I am setting up a database that has 5 seperate date fields per record.&nbsp;&nbsp;I need to set up a parameter query that will allow the user to input a beginning & ending date that will retrieve all records that fall between the dates.&nbsp;&nbsp;I have it set up to where it will do this with...

Part and Inventory Search

Back
Top