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
computer 3 xxx 10.13 Ian
computer 4 xxx 10.12 Mark