How do I prompt for criteria in a report?

[Guest]

Currently, I have a report that produces information grouped by Project
Number. Right now it gives data on every single Project Number in the
associated query.

I'd like for the user to be prompted to type in a single or multiple Project
Number(s) so that the report will produce only the information he seeks on
certain projects.

How do I go about this?

 

[Douglas J. Steele]

Assuming your report is based on a query, go into that query and put [Enter
Project Number] on the Criteria line under the Project Number field. When
the query is run (because of the report being invoked), a box will pop up,
allowing the user to specify the project number.

 

[Guest]

Thanks. That works well.

Can I set it so that if the user only knows the first four digits of the
project number (the project number format is ####-####), the query/report
will give all projects that begin with those 4 digits?
--
Thanks, Karen

Assuming your report is based on a query, go into that query and put [Enter
Project Number] on the Criteria line under the Project Number field. When
the query is run (because of the report being invoked), a box will pop up,
allowing the user to specify the project number.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Currently, I have a report that produces information grouped by Project
Number. Right now it gives data on every single Project Number in the
associated query.

I'd like for the user to be prompted to type in a single or multiple
Project
Number(s) so that the report will produce only the information he seeks on
certain projects.

How do I go about this?

 

[Douglas J. Steele]

Since your project number is text (as opposed to being a number), replace
the

[Enter Project Number]

you put in the Criteria cell with

LIKE [Enter as much as Project Number as you know] & "*"


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Thanks. That works well.

Can I set it so that if the user only knows the first four digits of the
project number (the project number format is ####-####), the query/report
will give all projects that begin with those 4 digits?
--
Thanks, Karen

Assuming your report is based on a query, go into that query and put
[Enter
Project Number] on the Criteria line under the Project Number field. When
the query is run (because of the report being invoked), a box will pop
up,
allowing the user to specify the project number.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Currently, I have a report that produces information grouped by Project
Number. Right now it gives data on every single Project Number in the
associated query.

I'd like for the user to be prompted to type in a single or multiple
Project
Number(s) so that the report will produce only the information he seeks
on
certain projects.

How do I go about this?