Page Header Not Printing On Every Page

  • Thread starter Thread starter Linda1485
  • Start date Start date
L

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
 
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.
 
Sorry, but I don't know how to create a constant expression in the subreport.
Could you explain in more detail? thanks
 
"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.
 
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
 
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]
 
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

Duane Hookom said:
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


Linda1485 said:
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
Click to expand...
Click to expand...
 
Back
Top