If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table Filter
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 |
#2
|
|||
|
|||
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 Nathan wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |
Manual line break spaces on TOC or Table of tables | Eric | Page Layout | 9 | October 29th, 2004 04:42 PM |
Automatic filling of fields in table two from table one | Jim Kelly | Database Design | 1 | September 27th, 2004 10:16 PM |
Name not showing ID is | René | Setting Up & Running Reports | 11 | June 29th, 2004 01:40 AM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |