ACCESS FEED

Senin, 26 Oktober 2026

Re: [MSAccessProfessionals] Group information addition #file-notice

Hi Jan

Sorry to see you go. You can leave the group by going to our home page.

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] Group information addition

I have to unsubscribe

On Mon, Oct 26, 2026 at 10:48 AM Bill Mosca via groups.io <wrmosca=myself.com@groups.io> wrote:

Just a reminder to all members...Please read our Group Description on our Home Page There is some important information recently added there.

--

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

[Special] [MSAccessProfessionals] Group information addition

Just a reminder to all members...Please read our Group Description on our Home Page There is some important information recently added there.

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Senin, 19 Oktober 2026

Re: [MSAccessProfessionals] SQL queries

See if this is what you're after:

http://allenbrowne.com/subquery-01.html#TopN

Paul

------ Original Message ------

From "Gary via groups.io" <glcshadow=hotmail.com@groups.io>

To MSAccessProfessionals@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

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

http://wrmosca.wordpress.com

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

[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.

_._,_._,_

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.

_._,_._,_