I have a query that I want to sort with two criterias

[Barry McConomy]

Hi

I have a query that I want to sort with two criteria's

1) Where there is no Fax number
2) Where there is a Fax number

I have tried "Is Not Null" and this does not work.

Can any body help.

Regards
Barry

 

[Allen Browne]

In a fresh column of the Field row in query design, enter:
([Fax] Is Null)
In the Sorting row under this, choose:
Ascending
You can uncheck the box in the Show row.

The expression is True when there is no fax number.
True sorts before False (because -1 comes before zero).

 

[Barry McConomy]

Allen

Many thanks for your help.

Barry

In a fresh column of the Field row in query design, enter:
([Fax] Is Null)
In the Sorting row under this, choose:
Ascending
You can uncheck the box in the Show row.

The expression is True when there is no fax number.
True sorts before False (because -1 comes before zero).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi

I have a query that I want to sort with two criteria's

1) Where there is no Fax number
2) Where there is a Fax number

I have tried "Is Not Null" and this does not work.

Can any body help.

Regards
Barry