Access Query Sort Order every other one

[Gina Maylone]

Hello again all,

I am trying to create a work schedule, some customers are scheduled for morning and others in the afternoon. I am trying to figure out how to sort AMs and PMs so I get a line with every other one. Make sense?

I thank you in advance for any tips you can give me.

[June7]

No, I do not understand. Show example of desired output.

[ranman256]

sort on the DATE field...AM will be 1st, PM will be last.

you cant skip lines.
tho in a report, you can show the AMs, skip a space , THEN show the PMs.