On Thu, 27 May 2010 23:33:35 GMT, "jfire via AccessMonster.com" u60367@uwe
wrote:

KARL DEWEY 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.

I have a problem, I enter employee ID into text box, I need to show all ID's
that have ck in on same form. I have table with employee ID info. I need
[quoted text clipped - 8 lines]

.
Karl the DB is not on a server at this time only on a single PC. I could
send you a zip copy of what I have, if so I could past a email address you
could contact me and I could send it to you. Sorry that's all I can do right
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.
--

John W. Vinson [MVP]