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!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- verstapp
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
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...- verstapp
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
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...- verstapp
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
