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!

Recent content by jrflanne

  1. jrflanne

    query to obtain a value from the next record down

    Thanks for responding. The sort order is by Name and then Depth. In geology-speak, the Layer is assumed to become older by increasing depth so Layers gamma and zeta are older than Layer beta. What I am interested in is what Layer does beta rest on.
  2. 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...
  3. jrflanne

    Summary query question

    Gad that was FAST! Thanks a lot. Jack
  4. 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...
See more

Part and Inventory Search

Back
Top