Table Filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
Is it possible in a table to filter data by setting two columns. My table
contains two columns containing data as shown:
Site Name Block Name

site1 block1
site1 block1
site1 block2
site1 block3

I need the data sorted alphabetically so I applied the a-z filter to the
Site Name column which it does. However as there are various different blocks
within the same site when it is sorted the blocks get jumbled up. Is there
any way to sort the site name alphabetically and then sort the block names
alphabetically within the site name filter.
Cheers
Nathan
 
Nathan,

There is little point in trying to sort a table; tables are just record
repositories, they are not intended for presenting data, consequently
not much sorting functionality there. Instead, make a query on the table
and sort in there, where you have the possibility to sort on as many
fields as you want; just remember sorting is applied left to right in
the query design view.

HTH,
Nikos
 
Back
Top