If statements in OrderBy

[Bruce]

Is it possible to sort by two separate criteria within the one OrderBy
statement depending on certain criteria?

To clarify:

My database holds job numbers of both Promotional Jobs and
Commissioned Jobs. I want to be able to print a report and display a
datasheet form that displays all of these numbers together, but
separated into their own groups and sorted within their groups.

I was thinking that maybe there was a way to sort: IF Promotional
THEN....ELSE...

Does anyone know if this is possible, and if not, any other way to
accomplish this?

Cheers,
Bruce Walker

 

[Jeff Boyce]

Bruce

From your description, it sounds like you could use a "Totals" query, using
GroupBy for each of the two characteristics.