Page Header Not Printing On Every Page


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
 
Ad

Advertisements

D

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.
 
L

Linda1485

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

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.
 
L

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
 
D

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]
 
Ad

Advertisements

L

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

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
 

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