Problem with a report

G

Guest

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
 
G

George Nicholson

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

Guest

I've done this, but I'm getting an error "Unidentified
function "Left" in expression" Any advice on this?
 
D

Duane Hookom

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