Sorting Reports with multiple criteria

[bitterman99]

I have a report that includes a coordinator one, coordinator two and coordinator three. I would like to have a "group report" that is broken down by coordinator. In other words I would like to have a report that would look for "Sally Smith" whether she was a coordinator one, two or three and then group everything she worked on. Basically I would like the report to group each coordinator then give a complete group total.

Any Help??

Thanks

 

[sdk]

Hi

I think you will find that running a report wizard will give you the start you are looking for.

(It would also be highly unlikely that the wizrd will give you the output format you are looking for


Cheers

S

 

[dhookom]

You have an un-normalized table structure. You can use a UNION QUERY to normalize it:
SELECT t.*, t.[Coordinator one] as TheCoordinator
FROM tablename t
UNION ALL
SELECT t.*, t.[Coordinator two]
FROM tablename t
WHERE [Coordinator two] is not null
UNION ALL
SELECT t.*, t.[Coordinator three]
FROM tablename t
WHERE [Coordinator three] is not null;

Base your report on this query.


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[sdk]

Hi

mea culpa - didn't read that problem into the question.

Cheers