I have a database that stores information from a form.
Just to clarify - it stores the information IN A TABLE, using the form
as a tool to put the data into the table. It's easy to make the
mistaken assumption that the Form is a data repository of some sort -
it's NOT.
I want to create some kind of report/form/query that will
only contain certain records depending on the data
contained in one of the columns. I am very new to access
and havent a clue as to what i need to do. I am using
Access2002 and would like to create several different sets
of data, again depending on the content of one column.
Create a Query based on your table. On the Criteria line under the
field that you want to use to select records, put the criterion that
selects the desired records. A couple of suggestions:
- Simplest is to just put the literal value. If you want to find all
records where the LastName field is "Jones", just type "Jones" on the
Criteria line. This is quick and easy but rather inflexible; you do
not want to end up with thousands of queries each with its own frozen
criterion!
- One step more flexible: use a Parameter Query by typing
= [Enter last name:]
on the Criteria line. When you open the query you'll get a popup box
prompting whatevery you type in the brackets, and Access will search
for whatever the user types.
- Better yet: create a small Form (let's call it frmCrit) with one or
more controls into which the user can type criteria. Use
=[Forms]![frmCrit]![nameofcontrol]
on the Criteria line.
In any of these cases, it's wise to create a Form (for onscreen
display) or a Report (for printing) based directly on this Query.
Don't make the common mistake of assuming that you need a new table in
order to generate a report - just use the Query.
.
