I appreciate your additional information. Even though you are somewhat new to this you have a good understanding of what you want.
The information I discuss below is taken from the link:
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…