How to include all records in a query

[Damien111]

I inherited an access query that used to include all employees when ran. Now it comes up asking for each individual employees info to run and then only includes that persons info. Does something have to be linked or changed so that all records are automatically included when running the query? I do not know Access so be gentle with me.

Jeff, MCP

 

[Cretin]

It would need to be changed unfortunately I am not expert enough in access to do it without seeing the query if you could show me how the query is set up I might be able to help.

Cretin

 

[JoeCruse]

Sounds like either someone stuck a parameter and criteria in the query, which will need to be removed, or filtered the query results and may have saved it with a filter (maybe?).

Joe

 

[scriverb]

Damien111: As stated above we need to see the details of your query to fix this for you. But, if you would like to try it yourself then follow these steps. Hopefully, this is stated in terms that you can understand with your limited ACCESS knowledge:

1. Open the query in Design view.
2. Look at the row titled Criteria near the bottom of the window. Study each column and look for an entry.
3. For all records to be selected there is at least one column that has an entry in the Criteria Row.
4. Remove this entry. Just highlight it and delete.
5. Save the query and close.

This should fix the query so that all records will be selected.

Post back if you have any questions.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???