[AccessD] Group and Page Break

Stuart McLachlan stuart at lexacorp.com.pg
Sun Mar 29 16:38:38 CDT 2009


If you want to break on every initial letter:

Set the GroupOn of LastName to "Prefix Characters"
Set the GroupInterval to 1 
Set the GroupHeader = "On"
Set ForceNewPage in the GroupHeader to "Before Section"

If you want to group by A-K, M-R, S-Z,
you can create a function and sort/group on that before your LastName sort/group.

Function GroupBlock(LastName as string) as long
Select Case UCase(Left(LastName,1))
   Case "A" to "K"
      GroupBlock = 1
  Case "M" to "R:
      GroupBlock = 2
   Case"S" to "Z"
      GroupBlock = 3
   Case Else 'capture numbers etc
      GroupBlock = 0  
End Select
End Function

Now either set a top sort/group of = "GroupBlock(LastName)"
or 
include GroupBlock(Lastname) as a field on your report's record source and group on it.



On 29 Mar 2009 at 10:01, Rocky Smolin at Beach Access  wrote:

> Exactly.  Its for the Toy Track app,actaully.  He wants the distribution
> list to page break on the first letter of the last name so that he can set
> up separate lines for toy pick up - like A-K, M-R, S-Z.  Stuff like that.
> So, essentially, a separate report for each letter of the alphabet.
> 
> 
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
> www.bchacc.com
>  
>  
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Sunday, March 29, 2009 9:58 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Group and Page Break
> 
> 
> > I'm trying to product a report that will page break on the first 
> > character of the last name field.
> 
> ========Huh? Do you mean when the first character changes or something?
> 
> Susan H. 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com





More information about the AccessD mailing list