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 Chriss Miller 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: erfigge
  • Content: Threads
  • Order by date
  1. erfigge

    select table data if the value does not include criteria

    I have two tables, One with instrument numbers, and then another table joined with instrument numbers that has all the data for each instrument. What I need to do is search the last records for each instrument and see if it is within the last 6 months. If the last record is not within the last...
  2. erfigge

    Select a set of data based off two criteria

    I don't even know how to search this to see if there is a faq already made on this, but let me explain my situation and then maybe it will make sense to somebody. I have two tables, One with instrument numbers, and then another table joined with instrument numbers that has all the data for each...
  3. erfigge

    multiple check query

    In a query I have a record field that I need to specify criteria for. The records in that field are of the form 2xxxxx, 3xxxxx - 9xxxxx ect. (the 2,3,4,5,6,7,8,9 denote different systems). Well, I have built a form with 9 checkboxes for the user to select which forms to run a query on. The...

Part and Inventory Search

Back
Top