what command in SQL Server  is equable "last" in MS Access?

To anyone who can help,
I'm trying to create a character string that will display output on two
different lines when an email notification goes out.  The email part works,
however, the output isn't what I'm looking for.  Here's the segment of code:

We are considering to install SQL Server and Access frontend on the Network.
We can have anywhere from 75 to 175 concurrent users for this application.
How can I set up SQL server as the backend and use Access as the front end
without causing application slow down and possible ...

I am wanting to add a box that pops up when i click on a report. When i click
on "Drilling Report" (name of report) i have 2 msg boxes that pop up.."Enter
Perameter Value" - "Date", i enter the date and click enter..then "Enter
Perameter Value" - "Rig" comes up, i enter the Rig name ...

I have a MainForm with three datasheet forms on it.
First form "SovItems" is auto linked to the MainForm
Second form "SovInstalled" is linked by a unbound box using txtLink, like I
found in the disucssin groups and it's working good.

I am trying to write code in Access VBA. I am going to run a select SQL to
read a record from a table then copy it into a variable. I am using
Private Sub Form_BeforeInsert(Cancel As Integer)
   Dim strSQL As String

I have a MainForm called MainForm, on the main form I have two datasheet
forms.
The first datasheet Form called SovItems and is linked to the MainForm with a
field called Division

I am working on ACCESS and SQL server. I am using Access ADP to development
some forms to read/write table on SQL server. I want to use RunSQL to execute
a select query and copy the output to a variable. How can I do that?
Thanks everyone

Does anyone have samples of how to list SQLServers on network in an ADP
combo box?
Thanks.
Alan

I have a parameter query (function), set-up with an SQL backend and ADP
frontend, that searches a table and the function works fine, but when I try
to set-up the combo box to the form, it isn't working correctly. When I open
the form it runs the function with the access default ...

I need to find all of the oracle servers running on our network, running on
various machines. Is there a tool available that can seek out these servers
Name , i have default port for it 1521 Or if there is code someone wrote to
do this, that would be equally helpful.

How can I programmatically retrieve and save the SQL for a View/SP/Function
from Access ADP.  I assume I'll have to use ADOX and the various Allxxx
collections, but have no idea of what to do beyond that.
Thanks,

I am giving up.  I figured maybe there was a bug in the Data Link dialog in
finding a named instance of Express, and so I tried uninstalling and
reinstalling in order to create a default instance, but it keeps creating
the named instance.  I even went so far as reinstalling VISTA ...

I am new to using an Access (2k) adp to work with SQL Server (2k). I'm not
sure what all I can do.
Can I append new records to the SQL Server db thru Access?
Thanks!

I made a table to register update,delete and insert from some tables, in
this table i have a field named user that take the 'system_user' as default
value and is working well, but in a field named eqp that i set 'host_name()'
as default value, it's catching the my station's host ...