If I put just the fields I want all the records just from those fields
shouln't it show just those records. I get every record in the database.
Could somebody help a newbie.
Sure. It would help a lot if you asked a clear question.
What do you mean by "put just the fields I want all the records just
from those fields"? I simply don't understand what you're doing.
A Table consists of zero, one, or many records; all of the records
have the same structure, the same number of fields of matching types.
A Query based on the table will let you choose which fields you want
to see; by putting criteria on the Criteria line in the query grid you
can select which records you want to see. For instance, if you have a
field named Department in your table and you want to see only the
records where Departement is equal to "Finance", you could type
"Finance" on the criteria line.
John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps