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 MikeeOK 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: lmid
  • Content: Threads
  • Order by date
  1. lmid

    how to return all detail records when using group by

    Hi, I have a table Trans Amount Code Date ID Trans_ID $5 JL 5/13/06 1 5876 $5 JL 5/13/06 1 245 $6 DR 01/06/05 3 6535 The trans_ID is a unique number for each record. I would like to do the something like: select code, amount, date from...
  2. lmid

    how to dynamically refer to a table in a query

    I have the names of several tables in a table called "MyTables", each table name as its own record, together with a checkbox. I want to make a query that will return records ONLY from the tables where that table's record in MyTables is checked. Is this even possible? How can I go about doing...

Part and Inventory Search

Back
Top