Go Back   Access World Forums > Search Forums

 
Showing results 1 to 2 of 2
Search took 0.00 seconds.
Search: Posts Made By: plog
Forum: Queries 09-22-2019, 02:00 PM
Replies: 6
Views: 171
Posted By plog
Re: Sort by MAX Version query - Very slow

You just moved the goalposts with your request. You initially mentioned 3 fields, now you dump 4 new ones into the equation. How GROUP BY queries work are hard for people to get their mind around....
Forum: Queries 09-20-2019, 08:58 AM
Replies: 6
Views: 171
Posted By plog
Re: Sort by MAX Version query - Very slow

I would do this with a subquery:


SELECT OPID, MAX(Version) AS LastVersion
FROM External2


Name that 'sub1'. It's going to find the highest Version for each OPID. Then use it in another...
Showing results 1 to 2 of 2

 
Forum Jump



All times are GMT -8. The time now is 06:58 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World