Hi Cadman
bit surprised that your database has only 6 or 7 fields - but anyway i'ld
first try using a parameter query and then if you get the "correct" records
for this, build a form for it.
to do the parameter query
create a new query in design view and add the table(s) that contain the
fields that you want to use as the criteria & see as the output
double click on these fields in the picture of the tables up the top so that
the fields do into the query grid, now run the query (red exclaimation mark
icon) ... okay should have lots of records, now return to design view (blue
protractor icon), and in the CRITERIA line for the two fields that you want
people to put numbers in type (include the square brackets)
[What number?]
(or similar)
now run the query again ... this time you should receive two prompts - if
you enter a number in each you should end up with a "filtered" results list.
if this works fine - let us know how you would like your users to see the
results - in a form or in a report.
Cheers
JulieD
cadman said:
I have a database with 6 or 7 fields. I want the user to be able to put in
numbers in two fields and return al the records that match those fields?
