John W. Vinson wrote:
Post the SQL of your query by opening in design view, click on VIEW - SQL
View, highlight all, copy, and paste in a post.
[quoted text clipped - 9 lines]
now.
John Firestone

Karl isn't talking about the client/server database product SQL/Server - he's
talking about the query within Access.

SQL (Structured Query Language) is the name of a language used by many
database programs - Access, SQL/Server, Oracle, DB/2, FoxPro, on and on. Every
query has a SQL view; in fact the query grid is simply a tool to build SQL,
and some people skip it entirely, just using the SQL window.

Open your query.

Select View from the menu.

Choose SQL from the dropdown.

Copy and paste the text that you will see, and Karl or one of the rest of us
will be able to help.



SELECT Date_Time_In.AT_Number, Resident_Info.L_Name, Resident_Info.F_Name,
Resident_Info.Unit_Number, Date_Time_In.[Date+Time_In]
FROM Resident_Info INNER JOIN Date_Time_In ON Resident_Info.At_Number =
Date_Time_In.AT_Number
ORDER BY Date_Time_In.[Date+Time_In] DESC;

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1