Query Sort problem!

[Bob V]

I am sorting a column by ascending, so how can I get the blank records/field
to the bottom, so as I have ascending then blanks,seem to recall something
about a flag???.....Thanks for any help...Bob

 

[Allen Browne]

In query design view, insert a new column to the *left* of the one you are
sorting on, and enter this in the Field row:
([MyField] Is Null)

Replace MyField with your field name.

In the Sorting row under this choose Descending.

 

[Bob V]

Thanks Alan, I have a problem now this delete is not really deleting so I
don't get the -1, what should I change this too??....Regards Bob
Private Sub cmdDeleteDate_Click()
cmbPersonlOrderSingle.value = ""
End Sub

In query design view, insert a new column to the *left* of the one you are
sorting on, and enter this in the Field row:
([MyField] Is Null)

Replace MyField with your field name.

In the Sorting row under this choose Descending.

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

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

I am sorting a column by ascending, so how can I get the blank
records/field to the bottom, so as I have ascending then blanks,seem to
recall something about a flag???.....Thanks for any help...Bob

 

[Douglas J. Steele]

Try using

cmbPersonlOrderSingle.value = Null


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Thanks Alan, I have a problem now this delete is not really deleting so I
don't get the -1, what should I change this too??....Regards Bob
Private Sub cmdDeleteDate_Click()
cmbPersonlOrderSingle.value = ""
End Sub

In query design view, insert a new column to the *left* of the one you
are sorting on, and enter this in the Field row:
([MyField] Is Null)

Replace MyField with your field name.

In the Sorting row under this choose Descending.

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

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

I am sorting a column by ascending, so how can I get the blank
records/field to the bottom, so as I have ascending then blanks,seem to
recall something about a flag???.....Thanks for any help...Bob

 

[Bob V]

Thanks Douglas,,,,Great
Bob

Try using

cmbPersonlOrderSingle.value = Null


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Thanks Alan, I have a problem now this delete is not really deleting so I
don't get the -1, what should I change this too??....Regards Bob
Private Sub cmdDeleteDate_Click()
cmbPersonlOrderSingle.value = ""
End Sub

In query design view, insert a new column to the *left* of the one you
are sorting on, and enter this in the Field row:
([MyField] Is Null)

Replace MyField with your field name.

In the Sorting row under this choose Descending.

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

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


I am sorting a column by ascending, so how can I get the blank
records/field to the bottom, so as I have ascending then blanks,seem to
recall something about a flag???.....Thanks for any help...Bob