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

    trying to get a 1to1 instead of a 1tomany join

    im trying to get a 1 to many join to be a 1 to 1 on a filtered criteria. So to simplify I have 2 tables Accounts | [acctnum], [name] Purchases | [acctnum], [ammount], [purchasedate] There can be many purchases to one account but I just want joins from its single most recent purchasedate. I've...
  2. peterlum

    Running total on

    Hi Im trying to get a count to carry over from month to month so theres a running total within the PERSON group but im having trouble since the count resets every PERSON. kinda like so DETAILS: [value] MONTH PERSON.1 COUNT of(value) PERSON.2 COUNT of(value) TOTAL X MONTH...

Part and Inventory Search

Back
Top