Hi,

What I want sounds simple but I can't work it out.

All of the computers in my database have a status of either '0' or '1'

Zero = computer is current

One= computer has been archived

I want a simple spreadsheet / report that will list ALL computers, but sort them into 2 listings

- top listing for current computers

- lower listing for archived computers

But I also need to have a breakpoint or heading so these 2 lists are differentiated.

Is this possible please?

It would look like this-(I have omitted the 'status' column)

List of current computers    Serial #    operating system    other info

computer 1                           xxx            10.15.7                     Fred

computer 2                          xxx            10.16                         Bruce

List of archived computers    Serial #    operating system    other info