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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
problem with subquery
Thanks so much folks, the version the PHV supplied did the trick...it works like a champ now. Note that I'm using @@Identity instead of the DMax() function to retrieve the newly-added record -- that seems to be working fine, but I think either would work in my situation.- VisiSteve
- Post #17
- Forum: Microsoft: Access Queries and JET SQL
-
problem with subquery
(Sorry if I'm hijacking the thread -- I think this is along the same lines though) Thanks George, the above syntax does seem to work against a single table however I'm still running into issues in my "real" scenario: I have 3 tables, Equipment, Measurement, and Equipment_Measurement...- VisiSteve
- Post #13
- Forum: Microsoft: Access Queries and JET SQL
-
problem with subquery
When I use a syntax identical to this in my database: Insert Into Table(Id, Name) Select (Select Max(Id) + 1 From Table), 'George' I receive the following error: Reserved error (-3025); there is no message for this error. I've tried several combinations of parenthesis, using SELECT or VALUES...- VisiSteve
- Post #10
- Forum: Microsoft: Access Queries and JET SQL
