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

    query to obtain a value from the next record down

    Hi, I have a question that might be simple for you to answer but I can't seem to figure it out. I've searched this forum some but can't seem to find the answer. The table structure is as follows: Name Layer Depth A1 alpha 50 A1 beta 100 A1 gamma 200 A1...
  2. jrflanne

    Summary query question

    Hi, Newbie warning! I have a table with three fields: caseID, custID, and pct_interest. I am looking for a way to find the maximum pct_interest for each caseID and then write caseID, the custID who has the maximum pct_interest and pct_interest for that caseID (GroupBy caseID). caseID...

Part and Inventory Search

Back
Top