Filtering Data for a Report

[Guest]

It has been a LONG time since I wrote an Access Program! I'm knew my mind
had dumped alot of info, but "oh my".

I need prompts prior to the report opening. Such as data field prompts. My
table and query has a year field (4 digit format) and a month field (entered
as "1" thru "12"). I need report runners to be able to select the year and a
month range prior to the report opening. Allowing operators to view
quarterly and annual data.

I hope I made since, I've also lost the lingo! So very sorry!!

 

[Guest]

Create a form with some controls for your users to select/enter year and
month values. I would actually have two text boxes for entering the beginning
and ending dates. Then create some code that would apply a filter in the
Where Condition of the DoCmd.OpenReport method.

Do you really only have year and month fields rather than full dates? Are
these numeric or text fields? What are their exact names? What is the name of
the report?

 

[Guest]

Duane,

Thank you!

The table is imported from Alabama Dept. of Public Health program that we
Rape Crisis Centers across the state use to input data. I am trying to
create reports that we can use to verify our data against the states data. I
can't alter the form, nor the table.

Yes, in this Crisis Call module we enter the year in four digit format and
we select the correct month for which the data represents (we only tally up
crisis calls and enter one time per month for the entire month). However
from the form, the report recognizes January as "1" February as "2" etc.

I use to be able, to set criteria when I ran a report. I programmed the
report to prompt , "Beginning Date" and "Ending Date". I would like to
program this to prompt , "Year" "Beginning Month" and "Ending Month".

The fields name: "RCCYear" "RCCMonth"

Thank you!