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 Rhinorhino 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 verstapp

  1. verstapp

    Problem with join

    Oops, how embarrassment! My problem is that I do this sort of thing so rarely that I forget a lot between times. Works now, thanks heaps.
  2. verstapp

    Problem with join

    2 tables: assets: ... [asset id] ... pvtorecycle: fred Both fields are text. Prior to updating certain records in assets i first try to find them using values previously typed into pvtorecycle.fred. SELECT * FROM assets WHERE pvtorecycle.fred = assets.[asset id]; However, when I run the...
  3. verstapp

    Query output

    I have a query which takes a user-supplied parameter and produces an output like this Date Count parameter x === ============ SELECT [asset tests].[test date], count(assets.[asset key]) FROM [asset tests] LEFT JOIN assets ON ([asset tests].[asset id] = assets.[asset key]) and (assets.[test...
  4. verstapp

    Change Phone number format

    Answered here http://www.tek-tips.com/viewthread.cfm?qid=1489326&page=1
  5. verstapp

    outer join problem

    Thanks, r937. Exactly what I was looking for.
  6. verstapp

    outer join problem

    The old 'how many detail lines does each master record have', with a twist. I have 2 tables, A: key, integer1, ...; and B: key, testdate, ... Basically, A is master records, B is detail lines, related by A.key = B.key. What I am looking for is a query generating: testdate, counta where testdate...
See more

Part and Inventory Search

Back
Top