Show Report months ontop of the report?

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

Guest

How do you show the reoprt months on the top of a report?

Needs to look like this: mm/dd/ccyy to mm/dd/ccyy

The above months will come from a query which is Enter first month and enter
second month.

thank you
 
How do you show the reoprt months on the top of a report?

Needs to look like this: mm/dd/ccyy to mm/dd/ccyy

The above months will come from a query which is Enter first month and enter
second month.

thank you
Click to expand...

Add an unbound congtrol to the report header.
Set it's Control Source to:
= "For sales from " & [Enter first month] & " to " & [Enter second
month]

The text within the brackets MUST be identical to the bracketed text
in the query criteria.
 
Thank you worked perfectly!

fredg said:
How do you show the reoprt months on the top of a report?

Needs to look like this: mm/dd/ccyy to mm/dd/ccyy

The above months will come from a query which is Enter first month and enter
second month.

thank you
Click to expand...

Add an unbound congtrol to the report header.
Set it's Control Source to:
= "For sales from " & [Enter first month] & " to " & [Enter second
month]

The text within the brackets MUST be identical to the bracketed text
in the query criteria.
Click to expand...
 
I can across a problem with this. When I go run my report it as for the
parameter twice. Once from the query and once from the expression I used
above. Any ideas to get around this? Thanks again

fredg said:
How do you show the reoprt months on the top of a report?

Needs to look like this: mm/dd/ccyy to mm/dd/ccyy

The above months will come from a query which is Enter first month and enter
second month.

thank you
Click to expand...

Add an unbound congtrol to the report header.
Set it's Control Source to:
= "For sales from " & [Enter first month] & " to " & [Enter second
month]

The text within the brackets MUST be identical to the bracketed text
in the query criteria.
Click to expand...
 
I can across a problem with this. When I go run my report it as for the
parameter twice. Once from the query and once from the expression I used
above. Any ideas to get around this? Thanks again

fredg said:
How do you show the reoprt months on the top of a report?

Needs to look like this: mm/dd/ccyy to mm/dd/ccyy

The above months will come from a query which is Enter first month and enter
second month.

thank you
Click to expand...

Add an unbound congtrol to the report header.
Set it's Control Source to:
= "For sales from " & [Enter first month] & " to " & [Enter second
month]

The text within the brackets MUST be identical to the bracketed text
in the query criteria.
Click to expand...
Click to expand...

Did you make sure of this >>>>>
"The text within the brackets MUST be identical to the bracketed text
in the query criteria."
For example, [Enter first month] is not the same as [Enter first
month:]
 
Yes but it is still doing it? Hum!

fredg said:
I can across a problem with this. When I go run my report it as for the
parameter twice. Once from the query and once from the expression I used
above. Any ideas to get around this? Thanks again

fredg said:
On Mon, 2 Oct 2006 08:30:02 -0700, TKM wrote:

How do you show the reoprt months on the top of a report?

Needs to look like this: mm/dd/ccyy to mm/dd/ccyy

The above months will come from a query which is Enter first month and enter
second month.

thank you

Add an unbound congtrol to the report header.
Set it's Control Source to:
= "For sales from " & [Enter first month] & " to " & [Enter second
month]

The text within the brackets MUST be identical to the bracketed text
in the query criteria.
Click to expand...
Click to expand...

Did you make sure of this >>>>>
"The text within the brackets MUST be identical to the bracketed text
in the query criteria."
For example, [Enter first month] is not the same as [Enter first
month:]
Click to expand...
 
You should kick your application up a notch and remove all parameter prompts
from queries. Use references to controls on forms. This would mean setting
your criteria to something like:

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

You can then use a control source in your report like:

="For sales from " & Forms!frmDates!txtStart & " to " &
Forms!frmDates!txtEnd

--
Duane Hookom
MS Access MVP

TKM said:
Yes but it is still doing it? Hum!

fredg said:
I can across a problem with this. When I go run my report it as for the
parameter twice. Once from the query and once from the expression I
used
above. Any ideas to get around this? Thanks again

:

On Mon, 2 Oct 2006 08:30:02 -0700, TKM wrote:

How do you show the reoprt months on the top of a report?

Needs to look like this: mm/dd/ccyy to mm/dd/ccyy

The above months will come from a query which is Enter first month
and enter
second month.

thank you

Add an unbound congtrol to the report header.
Set it's Control Source to:
= "For sales from " & [Enter first month] & " to " & [Enter second
month]

The text within the brackets MUST be identical to the bracketed text
in the query criteria.
Click to expand...

Did you make sure of this >>>>>
"The text within the brackets MUST be identical to the bracketed text
in the query criteria."
For example, [Enter first month] is not the same as [Enter first
month:]
Click to expand...
Click to expand...
 
Back
Top