Rpt and SubRpts with dates

[Linda RQ]

Hi Everyone,

Using Access 2003. I have a report that gets it's records from a parameter
query where the user enters the between dates for employee sick time. So If
I enter 9/1/08 thru 5/31/08 I get all the sick days taken by each employee
between those dates. I also have 2 sub reports on this report, the record
sources are different tables, 1 is for Discipline dates and the other shows
FMLA dates. The problem is both of these reports give me all dates. How
can I get my subreports to show the records between these dates? I am not a
"real" programmer so let me know if there is anthing else I need to give you
to help me on this.

Thanks,
Linda

 

[Duane Hookom]

IMO, never use parameter prompts http://www.tek-tips.com/faqs.cfm?fid=6763.
Parameter prompts in the criteria of queries is fairly common but have too
many limitations. IMHO, users should never be subjected to them.

They don't allow defaults
They don't allow picking from a list
They don't allow seeing multiple values at once
They aren't easily re-used
You can't check their integrity
You can't limit one based on the value of another
They don't support input masks or formats
Their values can't be displayed in a report that returns no records
They are annoying like pop-ups
They are difficult to query with a foreign key value that has no meaning
You rarely if ever find a parameter prompt type interface in any decent
software application

Use controls on forms for all of your user interaction.

 

[Linda RQ]

Thanks Duane...I guess this means a big fat NO and I'll need to just pull a
report for each item for now until I learn to create controls like this on
forms.

Linda

 

[Duane Hookom]

It's not all that difficult to implement something like this. Assuming you
create a form [frmDates] with two text boxes [txtStart] and [txtEnd]. You
report record source queries would have a criteria under the date column of

Between Forms!frmDates!txtStart and Forms!frmDates!txtEnd

Open the report after the form is open and the user has entered the dates.

 

[Linda RQ]

Thanks Duane,

I'll print this and give it a try

Linda

It's not all that difficult to implement something like this. Assuming you
create a form [frmDates] with two text boxes [txtStart] and [txtEnd]. You
report record source queries would have a criteria under the date column
of

Between Forms!frmDates!txtStart and Forms!frmDates!txtEnd

Open the report after the form is open and the user has entered the dates.
--
Duane Hookom
Microsoft Access MVP

Thanks Duane...I guess this means a big fat NO and I'll need to just pull
a
report for each item for now until I learn to create controls like this
on
forms.

Linda