Prev: report detail order
Next: new to reports
From: AndyK on 14 Jul 2008 18:21
hi all

I have a report where a I need a group header and detail sections, but
grouped on a combination of two fields, not just one - can't find a way of
doing this, is it possible?

thanks!
From: Marshall Barton on 14 Jul 2008 18:39
AndyK wrote:
>I have a report where a I need a group header and detail sections, but
>grouped on a combination of two fields, not just one - can't find a way of
>doing this, is it possible?


Depends on what you mean by "combination of two fields"

You can use an expression in the Sorting and Grouping -
Field/Expression cell. So, if your "combination" is
something simple like last name and first name, just group
on an expression like:
=lastname & "," & firstname

--
Marsh
MVP [MS Access]
From: AndyK on 14 Jul 2008 19:00
Thats exactly what I needed - thanks!

"Marshall Barton" wrote:

> AndyK wrote:
> >I have a report where a I need a group header and detail sections, but
> >grouped on a combination of two fields, not just one - can't find a way of
> >doing this, is it possible?
>
>
> Depends on what you mean by "combination of two fields"
>
> You can use an expression in the Sorting and Grouping -
> Field/Expression cell. So, if your "combination" is
> something simple like last name and first name, just group
> on an expression like:
> =lastname & "," & firstname
>
> --
> Marsh
> MVP [MS Access]
>
 | 
Pages: 1
Prev: report detail order
Next: new to reports