Access Filtering
I have a database which has multiple Product fields ( Prod Name, Prod Name 1, Prod Name 2, Prod Name 4). It is set up this way because one customer can order more than one product up to about four. The products are listed by number and the users can enter a product number into [...]

Answer Question   |  March 31, 2012  5:37 PM
Access 2007, columns, Design, filter, formulas, Search, SORT, totals functions

Filter & sort data tables in excel 2007
When I create a table in excel with data from an external data source using MS query, the resultant excel table doesn’t allow me to filter or sort the data (the menu options are greyed out) If I add columns with formulae to the right of my data table, it seems to view the two [...]

Answer Question   |  April 26, 2010  12:59 PM
Data Tables, Excel 2007, filter, MS Query