Report Narrowing Question

  • Thread starter Thread starter Chris21788
  • Start date Start date
C

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
 
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.
 
Back
Top