Quesry criteria

  • Thread starter Thread starter stacy
  • Start date Start date
S

stacy

I have a 2003 access file with a query that I need to set a criteria for. I
need to add full time abc techs with part time abc techs per district making
it less than 3 abc techs per location.
 
Your description is not clearly stated. Please restate what you're seeking
for the query to do, and give us some information about the table structure,
including field names, etc.
 
I have a 2003 access file with a query that I need to set a criteria for.
Copy toy SQL and post by opening the query in design view, click on menu
VIEW - SQL View, highlight all in the new window, copy, paste in a post.

Also post some sample data.
 
I have a 2003 access file with a query that I need to set a criteria for. I
need to add full time abc techs with part time abc techs per district making
it less than 3 abc techs per location.
Click to expand...

Nobody can possibly help you given this information.

We cannot see your computer. We do not know the structure of your table. We do
not know what an "abc tech" is, what a location means, or what your query is
designed to accomplish.

Step back a bit, and reread your question with the attitude that you have
never seen this database before in your life. Then post it with enough
information that someone in that position might be able to help you.

John W. Vinson [MVP]
 
Back
Top