limiting report data

  • Thread starter Thread starter marta
  • Start date Start date
M

marta

Hello,
I have a query with this data set:

name1 type1 valn
name2 type2 valn
name1 type2 valn
name3 etc.

My report is organized like this:

name
type val

it lists all names in my query

Is it possible to set a parameter in my report to limit
the names shown? Say I only want to display name1.

Thanks for your help!
Marta
 
I hope you did not use "name" as a variable since this is
a reserved word.
Let us say in your query you have the variable LName, to
limit to printing the report for just a selected name you
could enter "[Enter Name]" in the criteria (without the
quotes). This would ask you each time when you open this
query for "Enter Name" this would work provided you never
have duplicate names and you spell the name correctly.
An other option is to enter
Like "*" & [Enter Name] & "*"
(just as I wrote it) in the criteria. This will still ask
for the name each time but you could enter just a few
letters of the name, however the report will than be
printed for each name containing the letters in the same
sequence.
A third option is to print the report from a form where
you can have the name or ID number and you can set the
query to equal the specified field on the form. This is
the most accurate (restrictive) way of doing it.
Hope this gets you started.
Fons
 
Back
Top