Problem with a report

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
- 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.
 
I've done this, but I'm getting an error "Unidentified
function "Left" in expression" Any advice on this?
 
Go to Google Groups and search on
Unidentified function Left in expression Access
You will find a possible solution.
 
Back
Top