Viewing a Range of Date in A Report

G

G.Allen

Is there a way to show in a HEADER or FOOTER a range of dates. Have created a query for a report, which sums various data, but I would like to show on the report the dates which the data is pulled. And thank you all in advance and Merry Christmas...Happy Holidays!
 
L

Ling

Hi, your screen name doesn't show properly for me.

Not sure if this will help you, but here goes, my 1st try at 'helping'
someone:

Assuming your query asks for parameter entry to run the report for, if
you simply want to print the parameter(s) entered, try this:
In design view of course, in the Page Header (Not the report header,
unless you only want headers on the 1st page), insert a Text box where
you want it.
In the Control Source property for the text box, enter the same exact
parameter that you have in your query, for example [Enter Beginning
Date:]
The label for the text box can say something like "Report Run Date" or
whatever your parameter is asking for.

Another way you can do this is if you are passing parameters to a
report from an entry Form (using an unbound field name) instead of a
parameter query:
Again, in the report's page header (or footer), insert a text box.
For the Control Source, enter the expression
=Forms!FormName!FormFieldNameUsed
the "=Forms!" part is necessary, then you replace the FormName with the
form you are passing the params from, and the FormFieldNameUsed is the
unbound field name the parameter is from.

Hope this helps, and if anyone sees that this is wrong, please reply!
I may not have the greatest explanation skills just yet.


Ling
 
J

Jim/Chris

I use a form to generate my reports. In the form are 2
unbound fields for the beginning and ending date range.

I reference the dates in the report by placing
Me![beginningDate] as the control source

Jim
-----Original Message-----
Is there a way to show in a HEADER or FOOTER a range of
dates. Have created a query for a report, which sums
various data, but I would like to show on the report the
dates which the data is pulled. And thank you all in
advance and Merry Christmas...Happy Holidays!
 
G

G Allen

Thank you and most helpful.

----- Jim/Chris wrote: -----

I use a form to generate my reports. In the form are 2
unbound fields for the beginning and ending date range.

I reference the dates in the report by placing
Me![beginningDate] as the control source

Jim
-----Original Message-----
Is there a way to show in a HEADER or FOOTER a range of
dates. Have created a query for a report, which sums
various data, but I would like to show on the report the
dates which the data is pulled. And thank you all in
advance and Merry Christmas...Happy Holidays!
 
G

G Allen

Thank You!

----- Ling wrote: -----


Hi, your screen name doesn't show properly for me.

Not sure if this will help you, but here goes, my 1st try at 'helping'
someone:

Assuming your query asks for parameter entry to run the report for, if
you simply want to print the parameter(s) entered, try this:
In design view of course, in the Page Header (Not the report header,
unless you only want headers on the 1st page), insert a Text box where
you want it.
In the Control Source property for the text box, enter the same exact
parameter that you have in your query, for example [Enter Beginning
Date:]
The label for the text box can say something like "Report Run Date" or
whatever your parameter is asking for.

Another way you can do this is if you are passing parameters to a
report from an entry Form (using an unbound field name) instead of a
parameter query:
Again, in the report's page header (or footer), insert a text box.
For the Control Source, enter the expression
=Forms!FormName!FormFieldNameUsed
the "=Forms!" part is necessary, then you replace the FormName with the
form you are passing the params from, and the FormFieldNameUsed is the
unbound field name the parameter is from.

Hope this helps, and if anyone sees that this is wrong, please reply!
I may not have the greatest explanation skills just yet.


Ling
 
L

Ling

guess it worked!
you're quite welcome

even with books, sometimes it's just faster, easier, and simply better
to do a Google search on what you're trying to do, or check forums >
someone somewhere would have already done what you're trying to do!

HappyToHelp


Ling
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top