DMax in query but 2 possible IDs for criteria

User avatar
Peter Kinross
5StarLounger
Posts: 962
Joined: 09 Feb 2010, 00:33
Location: Patterson Lakes, Victoria, Australia

DMax in query but 2 possible IDs for criteria

Post by Peter Kinross »

Can't get this query to work. Cannot successfully differentiate between the 2 IDs
See 2 of my attempts attached
You do not have the required permissions to view the files attached to this post.
Avagr8day, regards, Peter

User avatar
HansV
Administrator
Posts: 78237
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: DMax in query but 2 possible IDs for criteria

Post by HansV »

I don't see why the second one wouldn't work. How about

ThisOB: (SELECT Max(Q.OnBoardingCommencedTbl) FROM tblOnBoarding AS Q WHERE Q.ID=tblOnBoarding.ID)
Best wishes,
Hans

User avatar
Peter Kinross
5StarLounger
Posts: 962
Joined: 09 Feb 2010, 00:33
Location: Patterson Lakes, Victoria, Australia

Re: DMax in query but 2 possible IDs for criteria

Post by Peter Kinross »

Thanks Hans. I realized that I should have put the DMAx statement in the Criteria part of the query design. When I realized that, about 10 mins after posting, I deleted the post. Or at least I thought I did. :sad:
Soon after that, I realized that I didn't need it for what I wanted to achieve.
Avagr8day, regards, Peter