Senin, 19 Oktober 2026

Re: [MSAccessProfessionals] SQL queries

See if this is what you're after:



Paul


------ Original Message ------
From "Gary via groups.io" <glcshadow=hotmail.com@groups.io>
Date 10/19/2026 2:38:53 PM
Subject [MSAccessProfessionals] SQL queries

Just curious if in SQL there was an easy way to pull up the latest data from a database for different locations.  I have a database that contains inspection results for many different locations.  I wanted to pull up the latest inspection for each site and make a report on it.  I thought the "TOP" command might work, and it does for just one site.  I would think that SQL would be able to handle that easily, but I have not been able to find anything in SQL that will do it.   Just was wondering if I have missed something in SQL.  I was able to do what I wanted in VBA.  Thanks --  Gary
Diposting oleh di Tidak ada komentar:

Re: [MSAccessProfessionals] SQL queries

Gary, my favorite source for queries is SQL For Smarties. It's available in  PDF at 
--https://cdn.bookey.app/files/pdf/book/en/joe-celko's-sql-for-smarties.pdf
 
Regards,
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP 2010-2016
My nothing-to-do-with-Access blog
 
_._,_._,_
Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116785) | Reply to Group | Reply to Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_
Diposting oleh di Tidak ada komentar:

[MSAccessProfessionals] SQL queries

Just curious if in SQL there was an easy way to pull up the latest data from a database for different locations.  I have a database that contains inspection results for many different locations.  I wanted to pull up the latest inspection for each site and make a report on it.  I thought the "TOP" command might work, and it does for just one site.  I would think that SQL would be able to handle that easily, but I have not been able to find anything in SQL that will do it.   Just was wondering if I have missed something in SQL.  I was able to do what I wanted in VBA.  Thanks --  Gary
_._,_._,_
Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116784) | Reply to Group | Reply to Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_
Diposting oleh di Tidak ada komentar:

Re: [MSAccessProfessionals] File Section Archive

Many thanks to the organisers & the many contributors for their input & wisdom. This site has got me out of many holes & I'll be really sorry to see it go. 
Best regards
Jane
_._,_._,_
Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116783) | Reply to Group | Reply to Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_
Diposting oleh di Tidak ada komentar:

Minggu, 18 Oktober 2026

Re: [MSAccessProfessionals] File Section Archive

Thanks so much, these are awesome, Crystal is amazing!

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Bill Mosca via groups.io <wrmosca=myself.com@groups.io>
Sent: Saturday, 17 October 2026 13:29:55
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [Special] [MSAccessProfessionals] File Section Archive
 
Thanks to the hard work by one of our owners, Crystal, the Files section of our group has been archived at her website 
Please use that link to peruse/download  the files we have gathered over the years. Many thanks to all members who have taken the time to post all the useful material found there.
 
That site is rich with information about MS Access.
--
Regards,
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP 2010-2016
My nothing-to-do-with-Access blog
 
Diposting oleh di Tidak ada komentar:

Sabtu, 17 Oktober 2026

Re: [MSAccessProfessionals] File Section Archive

thanks, Bill ! and for your many years of hosting this forum to share Access knowledge.

Please, all of you, check the archive downloads to ensure they can be gotten and used okay.

If there are issues, let us know right away!

kind regards, 
crystal

On 10/17/2026 12:29 PM, Bill Mosca via groups.io wrote:
Thanks to the hard work by one of our owners, Crystal, the Files section of our group has been archived at her website 
Please use that link to peruse/download  the files we have gathered over the years. Many thanks to all members who have taken the time to post all the useful material found there.
 
That site is rich with information about MS Access.
--
Regards,
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP 2010-2016
My nothing-to-do-with-Access blog
 
Diposting oleh di Tidak ada komentar:

[MSAccessProfessionals] File Section Archive

 
--
Regards,
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP 2010-2016
My nothing-to-do-with-Access blog
 
_._,_._,_
Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116780) | Reply to Group | Reply to Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)