Report Narrowing Question

[Chris21788]

Hi, I'm new at Access. I'm linking Tables with an Excel
spreadsheet, and that is where i store, and edit my
data. I've linked tables with Access, but now i want to
create a report. I have this one section, it's 'C' (for
codes). I need to narrow it down so i can search for one
letter (such as M, E, F, or O). Is there a way to when
you click to open the report, that it asks you for which
code you want, from what date to what date? There's also
things i want for the report too, such as: Name, Date,
Desc, G. cost, G. Profit, etc. Is there a way to narrow
one down? Thanks for your help! Chris

 

[___]

Sounds like you need to base your report on a parameter query. Create a
query based on your linked table, Select the fields you want to view.
In the Criteria field under the date column place the following...

Between [Enter Start Date] and [Enter Ending Date]

Now when you run the query you will need to enter two dates.

As for searching for you letter, use the same criteria...

[Enter Letter]

under the column containing the letters. Now all you need to do is base
the report on the query.

HTH

 

[___]

Sounds like you need to base your report on a parameter query. Create a
query based on your linked table, Select the fields you want to view.
In the Criteria field under the date column place the following...

Between [Enter Start Date] and [Enter Ending Date]

Now when you run the query you will need to enter two dates.

As for searching for you letter, use the same criteria...

[Enter Letter]

under the column containing the letters. Now all you need to do is base
the report on the query.

HTH

 

[Jeff Boyce]

Chris

If you have multiple possible selection criteria for your report, I'd
suggest using an unbound form with unbound controls to "collect" those
criteria, and a query that refers to the form for its criteria. Then build
your report, based on the query.