Report Layout Organization Help

[dylan.greene]

I am trying to create a report where I can separate data by tables or sections instead of a giant list. Something like this:

HEADER

STREET= A STREET= B

STREET= C STREET= D

A standard report shows the data from A-Z or however you sort it in a list format.

If a group of people live on street A, some on B, C and D; I want to separate the 6-7 groups more visibly without just being in a big list.
I can be by some sort of separate table layout if possible or by making each group a different color font - just some way it is easier to distinguish the difference being on one page.

If anyone could provide me some help I would greatly appreciate it.

Dylan

[June7]

Don't really understand but here are some things for you to explore.

Report Grouping & Sorting functionality and VBA code to set backcolor of Group section according to some criteria.

Conditional Formatting of textboxes

[dylan.greene]

Conditional formatting of textboxes would probably work. The question I have is, how can you create multiple textboxes in a report and have each textbox show a different portion of data? So textbox "1" would show people with the last name of "Alpha". Textbox "2" would show people with the last name of "Beta"...and so on.

Thanks again so much!

[June7]

Try a conditional expression in query or textbox ControlSource:

=IIf(Left(LastName,1)="A",LastName,Null))

But that would mean empty textboxes for records that don't meet criteria

Maybe what you want is to create a grouping condition in report based on expression: Left(LastName,1)

[dylan.greene]

I am terrible with code and know really nothing about it.

So you're saying I type your code: =IIf(Left(LastName,1)="A",LastName,Null)) into the the textbox Control Source area? If I want all people with the last name of "Buck" in the first text box, would it be like: =IIf(Left(FIELD NAME,1)="Buck",FIELD NAME,Null)) ? Not sure which part should be the field name and the person's name.

[June7]

Back up. That expression in textbox will not put all 'Buck' names in 'first' textbox. It just won't show a name unless it is 'Buck'. You need to group and sort records in alphabetical order. Then can use expressions in textbox as one way to control HOW the data displays, or if it displays at all.

If you need a better understanding of report grouping & sorting, review http://office.microsoft.com/en-us/ac...010006894.aspx