Adding Date Range Prompt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I looked around and I couldn't find out how to add a date parameter to a
report. I want to have a prompt that asks for a start date and one that asks
for an end date. Then display all records between those dates. Should I put
that in the query? If so, how do I do that?

Also, this is for an inspection sheet that has 26 questions on it. The
report displays on the counts the number of questions answered where I want
to see the number of inspections. I was wondering if there was some way to
divide the number by 26 and if so how? this is what the control of the report
says:

="Summary for " & " " & [Crew Leader] & " (" & Count(*) & " " &
IIf(Count(*)=1,"detail record","detail records") & ")"

Thank you
 
Greg, I asked this same question last month. Go to the following three posts
in the "Access Database Forms Coding" group. You might find your answer.
Andy

1) Parameters are ignored when export & email command buttons are used,
7/15/2005
2) Multiple Parameters in a Form, 6/14/2005
3) Ok, so close, just need a little push to get form inputs into repo,
6/13/2005
 
Thanks you for your help.
--
Greg



Andy said:
Greg, I asked this same question last month. Go to the following three posts
in the "Access Database Forms Coding" group. You might find your answer.
Andy

1) Parameters are ignored when export & email command buttons are used,
7/15/2005
2) Multiple Parameters in a Form, 6/14/2005
3) Ok, so close, just need a little push to get form inputs into repo,
6/13/2005



Greg said:
I looked around and I couldn't find out how to add a date parameter to a
report. I want to have a prompt that asks for a start date and one that asks
for an end date. Then display all records between those dates. Should I put
that in the query? If so, how do I do that?

Also, this is for an inspection sheet that has 26 questions on it. The
report displays on the counts the number of questions answered where I want
to see the number of inspections. I was wondering if there was some way to
divide the number by 26 and if so how? this is what the control of the report
says:

="Summary for " & " " & [Crew Leader] & " (" & Count(*) & " " &
IIf(Count(*)=1,"detail record","detail records") & ")"

Thank you
Click to expand...
Click to expand...
 
Back
Top