Grouping with particular records at the top

[elsandalos]

Hi all,
I have a db for logging meeting action points. Each action point has a description and owner. I'd like a query/report which will produce a list of action points grouped by owner (easy), but with a particular owner's action points at the top.

Essentially, rather than do a GroupBy and ascending sort, i need to specify the first group that is displayed. I don't care in what order the other groups appear.

Eg.

Action Point          Owner
1. Task 1                DC
6. Task 6                DC
8. Task 8                DC
3. Task 3                AG
4. Task 4                AG

So, above if i just did an ascending sort, the DC records wouldn't be at the top.

any ideas?

El.

 

[FoFa]

You can do this using a false sort key.
Assumtion, the owner wanted at the top is selected on a form.
IIF(Forms!MyForm!Owner=[Owner],0,1)
as an example

 

[MStef]

Hello El.

Look at "DemoPartOrderA2000.mdb".
Only to explain what FoFa said.
Open Form1 and try.

 

[elsandalos]

Just the job! Many thanks - much simpler than i thought it would be

El.