Page Header Not Printing On Every Page

[Linda1485]

I am using Access 2007 on Windows Vista machine. I have a report with a
subreport and I can't get the page header in the subreport to print. In the
subreport I am using a group by and three sort levels. These fields are
printing in the group header only. I am trying to get them to repeat on the
subsequent pages of the group. I have put the same fields into the page
header. I assumed that the page header is what I needed to use to make this
happen. Any help would be appreciated. I am somewhat new to Access and self
taught.

thank you,

Linda

 

[Duane Hookom]

A subreport has no concept of pages since the main report handles all of
this. You can create a pseudo page header by creating a new highest level of
sorting and grouping on a constant expression like:
=1
Display the Header section for this level and set its Repeat Section to Yes.

 

[Linda1485]

Sorry, but I don't know how to create a constant expression in the subreport.
Could you explain in more detail? thanks

 

[Duane Hookom]

"by creating a new highest level of sorting and grouping on a constant
expression"
I assume you understand how to set the sorting and group levels in reports.
My solution is to add another level at the top and enter
=1
as the field/expression.

 

[Linda1485]

Thank you, I was able to get my group header printing on subsequent pages.
The problem I am having now is that I need to have one group header based on
two fields, date and time. I tried to create a group using an expression
similar to "=date, time", but this caused a syntax error. Can you tell me
how to do this?
thanks very much.

Linda

 

[Duane Hookom]

Are your fields actually named "Date" and "Time"? This would not be advisable
since they are both function names/reserved words.

However, the expression to use would match whatever might be entered into a
control source of a text box. I expect if these are both date/time datatypes,
you could use:
=[DateFieldName]+[TimeFieldName]

 

[Linda1485]

Your solution worked perfectly, thank you for all of your help, Duane. I'm
on to my next report.

BTW - My field names are "start date" and "start time".

- Linda

Are your fields actually named "Date" and "Time"? This would not be advisable
since they are both function names/reserved words.

However, the expression to use would match whatever might be entered into a
control source of a text box. I expect if these are both date/time datatypes,
you could use:
=[DateFieldName]+[TimeFieldName]

--
Duane Hookom
Microsoft Access MVP

Thank you, I was able to get my group header printing on subsequent pages.
The problem I am having now is that I need to have one group header based on
two fields, date and time. I tried to create a group using an expression
similar to "=date, time", but this caused a syntax error. Can you tell me
how to do this?
thanks very much.

Linda