How to Find the Maximum Value of Multiple Fields in the Same Record in Microsoft Access

[@salehabusall9201]

This is really good solution 👌 . Your video is quite helpful. Thank you Richard.

[@VladTepesh409]

Hi, Richard. I have an Access database that stores GPS data. The fields are date, time, GPS (latitude, longitude), and speed. The query result I am looking for is to only display the single, entire record with the smallest speed data field on a given day and range of time. I've managed to get it filtered by day and time using the 'use form field data in a query' feature for the date, and an 'greater than or equal to date of trip AND less than dateadd +59 seconds' query criteria in conjunction with 'use form field data in a query' for the time field. When my form fields have 12/5/2023 and 1:02:00, I get a query result something like this: TripDate; GPSTime; GPS; Speed 12/5/2023; 1:02:00; 45, -103; 20 12/5/2023; 1:02:15; 45, -102; 10 12/5/2023; 1:02:30; 45, -101; 0 12/5/2023; 1:02:45; 45, -100; 5 The final result I'm looking to display in the query results is only the record with '0' speed, because it's the record with the minimum speed of these results. In this way, a trip date of 12/5/2023 and reported pick-up time time of 1:02 from form fields would show me that at 1:02:30 (when) and 45, -101 (where), as the driver physically stopped their vehicle (minimum speed value), this is when and where the member was reportedly picked up by the driver. Now, there may be a point at where the speed is not '0' MPH, so I need it to display the record with the minimum speed of these results rather than just displaying records with '0' MPH in the speed field. Is that something you can help with?

[@mitchellfolbe8729]

The NCAA Tournament is coming up next month. Can you use cascading combo boxes to make a tournament bracket? Or is there a better way to do it in access?

[@heriramadhan5625]

Hi Richard very interested with this, can you help me how to find second maximum value in the same field.?

[@stephenbeswick2163]

Hi Richard very interested video again. Can you help with a little problem how do you auto fill in a text box with an email or an website address if you have time please many thanks steveB

[@ptzzycool]

Great stuff, I love it. By the way, it might be nice if you put together an assessment processing system done in Access rather than in Excel. It would involve calculating of percentage scores for different assessment items plus grading and ranking as well. Why I want it done in Access is because I thought that printing the reports right from within Access would be straight forward rather than merging everything to word from excel to do the printing. Also, printing reports with students' photos is much easier than doing it in excel. Thanks

[@599CD]

Well that sounds like an interesting project then it certainly might be something I could make some videos on but I'll need a little more information on exactly what you mean by an assessment processing system. Tell me more about what you need and maybe some screenshots of what you got in Excel and perhaps I can put something together. Contact me at [e-mail].

[@jasongonzalez1680]

Definitely an intermediate approach to solving this problem. The better way is to use Visual Basic and be done with it.

[@599CD]

That may be, but not all of my viewers want to learn VBA.

[@jasongonzalez1680]

Then show them the use of the "Switch" function@@599CD

[@gonefishing2006]

You asked. I reply. I would like to know how to do this the "correct way". I think I know how but I'd rather have the Access God show us how to do it correctly.