If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Problem with a report
- 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 |
#3
|
|||
|
|||
Problem with a report
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 . |
#4
|
|||
|
|||
Problem with a report
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 . |
Thread Tools | |
Display Modes | |
|
|