Parameter Report

[LMB]

Hi,

Can I set a parameter in a report or do I have to make a parameter query and then base the report on the query. I am wanting to make a report that only shows records between Jan 1 and Jan 31, or Feb 1 and Feb 29. I also don't want the year to be taken into consideration but the field I am pulling the information is in mm/dd/yy format.

Thanks,
Linda

 

[AlCamp]

Linda,
Use a parameter query as the RecordSource for your report. Your Date
field criteria would be...
Between [Enter Start Date] and [Enter End Date]
When the report opens the user is prompted for 2 date values, and the
records returned are filtered accordingly.

If you just placed
Between [Enter Start Date] and [Enter End Date]
on your report, you would still be asked for 2 date values at run time, but
they would only be held as values on the report. By the time you get to the
parameters on a report... the query has already run, and those entered
values have no filtering effect on the records returned.
You can enter m/d (ex. 1/2 or 3/15) as parameter values, and 2004 will be
understood. But, for any year other than the present "system" year, you'll
need to enter the year as well. (ex. 1/1/02)

hth
Al Camp

Hi,

Can I set a parameter in a report or do I have to make a parameter query and
then base the report on the query. I am wanting to make a report that only
shows records between Jan 1 and Jan 31, or Feb 1 and Feb 29. but the field
I am pulling the information is in mm/dd/yy format.

Thanks,
Linda

 

[LMB]

Hi Al,

I'm trying to use one query for many different reports so I don't want a parameter in the query unless this is the best way. I don't think I understand what you are saying about the "parameters on the report...the query has already run, and those entered values have no filtering effect on the records returned."

Maybe I'll explain the report and there is a better way for me to do this and maybe not <g>. We have employees who turn in portfolios every year. The months you can turn them in are in January, April, June, and October. The date within the month can be different from year to year. The table which stores the information has EmployeeID, PortfolioDate as two of the fields I am pulling the information from in my query. We want a report that shows which employee's portfolios are due on the next turn in date. So, this January, the people with a date of 1/5/04 in this query will show up on the list and I'll add a parameter on my report header [type date] so the employees are reminded the portfolios are due on that date this year.

BTW..this is Access 2000.

Thanks,
Linda

Linda,
Use a parameter query as the RecordSource for your report. Your Date
field criteria would be...
Between [Enter Start Date] and [Enter End Date]
When the report opens the user is prompted for 2 date values, and the
records returned are filtered accordingly.

If you just placed
Between [Enter Start Date] and [Enter End Date]
on your report, you would still be asked for 2 date values at run time, but
they would only be held as values on the report. By the time you get to the
parameters on a report... the query has already run, and those entered
values have no filtering effect on the records returned.
You can enter m/d (ex. 1/2 or 3/15) as parameter values, and 2004 will be
understood. But, for any year other than the present "system" year, you'll
need to enter the year as well. (ex. 1/1/02)

hth
Al Camp

Hi,

Can I set a parameter in a report or do I have to make a parameter query and
then base the report on the query. I am wanting to make a report that only
shows records between Jan 1 and Jan 31, or Feb 1 and Feb 29. but the field
I am pulling the information is in mm/dd/yy format.

Thanks,
Linda