Problem with a report

Hello:

I'm attempting to produce a report in Access. The report
will have page breaks when the header info changes. The
problem is that the pages will break when a portion of the
info changes. The report is by project #. The #'s go 22-
411-015, 23-411-001, 23-411-002, 24-411-003, 24-411-028
and so on. I'm looking to have this report display a
header whenever the first two digits (22,23 and 24)change.

Thank you

- Under Sorting and Grouping, make sure Project ID is included (and sorted
Ascending).
- Under Group properties for ProjectID: Set GroupHeader = Yes, GroupOn =
PrefixCharacters, and GroupInterval = 2

This should create a header whenever there is a change in the first 2
characters of the ProjectID.
--
George Nicholson

Remove 'Junk' from return address.


wrote in message
...
Hello:

I'm attempting to produce a report in Access. The report
will have page breaks when the header info changes. The
problem is that the pages will break when a portion of the
info changes. The report is by project #. The #'s go 22-
411-015, 23-411-001, 23-411-002, 24-411-003, 24-411-028
and so on. I'm looking to have this report display a
header whenever the first two digits (22,23 and 24)change.

Thank you

I've done this, but I'm getting an error "Unidentified
function "Left" in expression" Any advice on this?
-----Original Message-----
- Under Sorting and Grouping, make sure Project ID is
included (and sorted
Ascending).
- Under Group properties for ProjectID: Set GroupHeader =
Yes, GroupOn =
PrefixCharacters, and GroupInterval = 2

This should create a header whenever there is a change in
the first 2
characters of the ProjectID.
--
George Nicholson

Remove 'Junk' from return address.


wrote in message
...
Hello:

I'm attempting to produce a report in Access. The report
will have page breaks when the header info changes. The
problem is that the pages will break when a portion of
the
info changes. The report is by project #. The #'s go 22-
411-015, 23-411-001, 23-411-002, 24-411-003, 24-411-028
and so on. I'm looking to have this report display a
header whenever the first two digits (22,23 and 24)
change.

Thank you


.

Go to Google Groups and search on
Unidentified function Left in expression Access
You will find a possible solution.

--
Duane Hookom
MS Access MVP
--

wrote in message
...
I've done this, but I'm getting an error "Unidentified
function "Left" in expression" Any advice on this?
-----Original Message-----
- Under Sorting and Grouping, make sure Project ID is
included (and sorted
Ascending).
- Under Group properties for ProjectID: Set GroupHeader =
Yes, GroupOn =
PrefixCharacters, and GroupInterval = 2

This should create a header whenever there is a change in
the first 2
characters of the ProjectID.
--
George Nicholson

Remove 'Junk' from return address.


wrote in message
...
Hello:

I'm attempting to produce a report in Access. The report
will have page breaks when the header info changes. The
problem is that the pages will break when a portion of
the
info changes. The report is by project #. The #'s go 22-
411-015, 23-411-001, 23-411-002, 24-411-003, 24-411-028
and so on. I'm looking to have this report display a
header whenever the first two digits (22,23 and 24)
change.

Thank you


.