report label of sublabel on the fly???

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_Bigred

I have a report based on a query (which has several criteria in it).

Is there a way for me to create a label on the top of this report,
indicating what the data actually is
vs the report name?

E.G.

I have a query that will allow me to sort Baseball stats since 1970, I am
prompted to punch in a date range and team. I would like to be able to
(maybe) use a message box to put a more desired/specific report name on the
top of the report or maybe use a message box as a sub-title box.

Using Access 2000
TIA,
_Bigred
 
_Bigred said:
I have a report based on a query (which has several criteria in it).

Is there a way for me to create a label on the top of this report,
indicating what the data actually is
vs the report name?

E.G.

I have a query that will allow me to sort Baseball stats since 1970,
I am prompted to punch in a date range and team. I would like to be
able to (maybe) use a message box to put a more desired/specific
report name on the top of the report or maybe use a message box as a
sub-title box.
Using Access 2000
TIA,
_Bigred
Click to expand...

The easiset way I know is to run the report from a form.

If you have a startdate, enddate and teamName field your query would use

Between forms!YourFormName!StartDate AND forms!YourFormName!endDate
forms!YourFormName!teamName
as criteria

Your label would be a text box

"Report for " & forms!YourFormName!teamName & " between " &
Between forms!YourFormName!StartDate & " and " & forms!YourFormName!endDate
 
I'll check this out, and let you know.
_Bigred


Mike Painter said:
The easiset way I know is to run the report from a form.

If you have a startdate, enddate and teamName field your query would use

Between forms!YourFormName!StartDate AND forms!YourFormName!endDate
forms!YourFormName!teamName
as criteria

Your label would be a text box

"Report for " & forms!YourFormName!teamName & " between " &
Between forms!YourFormName!StartDate & " and " &
forms!YourFormName!endDate
Click to expand...
 
Back
Top