report footer

[Guest]

Duane,

I tried using a totals query as a record source of a subreport in my
report's footer section. The problem is my report's record source includes a
date field with the criteria Between [Type Start Date] And [Type End Date].
So when I add the subreport it ask me to type the start and end date about 4
times in the parameter value. If I could just have me ask the start and end
date once and sort the report and subreport, it would be perfect. Please help!

Thank you.

I expect you can create a totals query that looks like this. If so, use the
totals query as the record source of a subreport. Place the subreport in the
report's footer section.

 

[Duane Hookom]

Stop using parameter prompts in queries. Create an unbound form with text
boxes to enter the start and end dates. Reference these controls in your
query rather than parameter prompts.

--
Duane Hookom
MS Access MVP
--

Duane,

I tried using a totals query as a record source of a subreport in my
report's footer section. The problem is my report's record source includes
a
date field with the criteria Between [Type Start Date] And [Type End
Date].
So when I add the subreport it ask me to type the start and end date about
4
times in the parameter value. If I could just have me ask the start and
end
date once and sort the report and subreport, it would be perfect. Please
help!

Thank you.

I expect you can create a totals query that looks like this. If so, use
the
totals query as the record source of a subreport. Place the subreport in
the
report's footer section.

--
Duane Hookom
MS Access MVP

I have a made a report that has one group level that divides work hours by
pay type. In each group the hours are divded by regular and overtime
hours
and are summed at the bottom of the section. I need to make a report
footer
that will show the sum of regular and overtime hours by pay type, but I
don't
know how to generate those sums. Here is what I want it to look like

Regular
Overtime

Weekday x x
Weekend x x
Holidays x
x

Thanks!

 

[Guest]

Duane,

I haven't been using Access very long, so how do I do this? Also I am
using a report, not a form. Please keep helping, I really appreciate it!

Thanks!

Stop using parameter prompts in queries. Create an unbound form with text
boxes to enter the start and end dates. Reference these controls in your
query rather than parameter prompts.

--
Duane Hookom
MS Access MVP
--

Duane,

I tried using a totals query as a record source of a subreport in my
report's footer section. The problem is my report's record source includes
a
date field with the criteria Between [Type Start Date] And [Type End
Date].
So when I add the subreport it ask me to type the start and end date about
4
times in the parameter value. If I could just have me ask the start and
end
date once and sort the report and subreport, it would be perfect. Please
help!

Thank you.

I expect you can create a totals query that looks like this. If so, use
the
totals query as the record source of a subreport. Place the subreport in
the
report's footer section.

--
Duane Hookom
MS Access MVP

I have a made a report that has one group level that divides work hours by
pay type. In each group the hours are divded by regular and overtime
hours
and are summed at the bottom of the section. I need to make a report
footer
that will show the sum of regular and overtime hours by pay type, but I
don't
know how to generate those sums. Here is what I want it to look like

Regular
Overtime

Weekday x x
Weekend x x
Holidays x
x

Thanks!

 

[Duane Hookom]

Check this link http://www.fontstuff.com/access/index.htm. There are lots of
great samples on Dennis' page.

--
Duane Hookom
MS Access MVP
--

Duane,

I haven't been using Access very long, so how do I do this? Also I am
using a report, not a form. Please keep helping, I really appreciate it!

Thanks!

Stop using parameter prompts in queries. Create an unbound form with text
boxes to enter the start and end dates. Reference these controls in your
query rather than parameter prompts.

--
Duane Hookom
MS Access MVP
--

Duane,

I tried using a totals query as a record source of a subreport in
my
report's footer section. The problem is my report's record source
includes
a
date field with the criteria Between [Type Start Date] And [Type End
Date].
So when I add the subreport it ask me to type the start and end date
about
4
times in the parameter value. If I could just have me ask the start and
end
date once and sort the report and subreport, it would be perfect.
Please
help!

Thank you.

I expect you can create a totals query that looks like this. If so, use
the
totals query as the record source of a subreport. Place the subreport
in
the
report's footer section.

--
Duane Hookom
MS Access MVP


I have a made a report that has one group level that divides work hours
by
pay type. In each group the hours are divded by regular and overtime
hours
and are summed at the bottom of the section. I need to make a report
footer
that will show the sum of regular and overtime hours by pay type, but
I
don't
know how to generate those sums. Here is what I want it to look like

Regular
Overtime

Weekday x
x
Weekend x
x
Holidays x
x

Thanks!

 

[Guest]

Duane,

I tried using a few of Dennis' sample, but had no luck. I want to use
a dialog box with text boxes to enter the start and end dates and reerence
these controls in my query. I have one date field. I would really appreciate
it if you could just tell me how to do this under my circumstances. I'm
really sorry for the inconvience, but I know I won't be able to solve my
problem by looking at samples that have little to do with my problem.

Thank you for your continuing help.

Check this link http://www.fontstuff.com/access/index.htm. There are lots of
great samples on Dennis' page.

--
Duane Hookom
MS Access MVP
--

Duane,

I haven't been using Access very long, so how do I do this? Also I am
using a report, not a form. Please keep helping, I really appreciate it!

Thanks!

Stop using parameter prompts in queries. Create an unbound form with text
boxes to enter the start and end dates. Reference these controls in your
query rather than parameter prompts.

--
Duane Hookom
MS Access MVP
--

Duane,

I tried using a totals query as a record source of a subreport in
my
report's footer section. The problem is my report's record source
includes
a
date field with the criteria Between [Type Start Date] And [Type End
Date].
So when I add the subreport it ask me to type the start and end date
about
4
times in the parameter value. If I could just have me ask the start and
end
date once and sort the report and subreport, it would be perfect.
Please
help!

Thank you.

I expect you can create a totals query that looks like this. If so, use
the
totals query as the record source of a subreport. Place the subreport
in
the
report's footer section.

--
Duane Hookom
MS Access MVP


I have a made a report that has one group level that divides work hours
by
pay type. In each group the hours are divded by regular and overtime
hours
and are summed at the bottom of the section. I need to make a report
footer
that will show the sum of regular and overtime hours by pay type, but
I
don't
know how to generate those sums. Here is what I want it to look like

Regular
Overtime

Weekday x
x
Weekend x
x
Holidays x
x

Thanks!

 

[Duane Hookom]

Did you create a form with a text box for your criteria value? Make sure the
form is open and contains a value then open the query or a report based on
your query. The criteria in the query would be something like:
Forms!frmYourForm!txtStartDate

--
Duane Hookom
MS Access MVP

Duane,

I tried using a few of Dennis' sample, but had no luck. I want to use
a dialog box with text boxes to enter the start and end dates and reerence
these controls in my query. I have one date field. I would really
appreciate
it if you could just tell me how to do this under my circumstances. I'm
really sorry for the inconvience, but I know I won't be able to solve my
problem by looking at samples that have little to do with my problem.

Thank you for your continuing help.

Check this link http://www.fontstuff.com/access/index.htm. There are lots
of
great samples on Dennis' page.

--
Duane Hookom
MS Access MVP
--

Duane,

I haven't been using Access very long, so how do I do this? Also I
am
using a report, not a form. Please keep helping, I really appreciate
it!

Thanks!

:

Stop using parameter prompts in queries. Create an unbound form with
text
boxes to enter the start and end dates. Reference these controls in
your
query rather than parameter prompts.

--
Duane Hookom
MS Access MVP
--

Duane,

I tried using a totals query as a record source of a subreport
in
my
report's footer section. The problem is my report's record source
includes
a
date field with the criteria Between [Type Start Date] And [Type End
Date].
So when I add the subreport it ask me to type the start and end date
about
4
times in the parameter value. If I could just have me ask the start
and
end
date once and sort the report and subreport, it would be perfect.
Please
help!

Thank you.

I expect you can create a totals query that looks like this. If so,
use
the
totals query as the record source of a subreport. Place the
subreport
in
the
report's footer section.

--
Duane Hookom
MS Access MVP


I have a made a report that has one group level that divides work
hours
by
pay type. In each group the hours are divded by regular and
overtime
hours
and are summed at the bottom of the section. I need to make a
report
footer
that will show the sum of regular and overtime hours by pay type,
but
I
don't
know how to generate those sums. Here is what I want it to look
like

Regular
Overtime

Weekday x
x
Weekend x
x
Holidays x
x

Thanks!

 

[Guest]

Duane,

Thank you for your help! Works perfect! Sorry for the inconvienve.

Tandy

Did you create a form with a text box for your criteria value? Make sure the
form is open and contains a value then open the query or a report based on
your query. The criteria in the query would be something like:
Forms!frmYourForm!txtStartDate

--
Duane Hookom
MS Access MVP

Duane,

I tried using a few of Dennis' sample, but had no luck. I want to use
a dialog box with text boxes to enter the start and end dates and reerence
these controls in my query. I have one date field. I would really
appreciate
it if you could just tell me how to do this under my circumstances. I'm
really sorry for the inconvience, but I know I won't be able to solve my
problem by looking at samples that have little to do with my problem.

Thank you for your continuing help.

Check this link http://www.fontstuff.com/access/index.htm. There are lots
of
great samples on Dennis' page.

--
Duane Hookom
MS Access MVP
--

Duane,

I haven't been using Access very long, so how do I do this? Also I
am
using a report, not a form. Please keep helping, I really appreciate
it!

Thanks!

:

Stop using parameter prompts in queries. Create an unbound form with
text
boxes to enter the start and end dates. Reference these controls in
your
query rather than parameter prompts.

--
Duane Hookom
MS Access MVP
--

Duane,

I tried using a totals query as a record source of a subreport
in
my
report's footer section. The problem is my report's record source
includes
a
date field with the criteria Between [Type Start Date] And [Type End
Date].
So when I add the subreport it ask me to type the start and end date
about
4
times in the parameter value. If I could just have me ask the start
and
end
date once and sort the report and subreport, it would be perfect.
Please
help!

Thank you.

I expect you can create a totals query that looks like this. If so,
use
the
totals query as the record source of a subreport. Place the
subreport
in
the
report's footer section.

--
Duane Hookom
MS Access MVP


I have a made a report that has one group level that divides work
hours
by
pay type. In each group the hours are divded by regular and
overtime
hours
and are summed at the bottom of the section. I need to make a
report
footer
that will show the sum of regular and overtime hours by pay type,
but
I
don't
know how to generate those sums. Here is what I want it to look
like

Regular
Overtime

Weekday x
x
Weekend x
x
Holidays x
x

Thanks!