I'm looking for a simple line or two of code to sort an Access able by a specific field. Thus far I have tried the following and some variations of it but without success. I want to sort the field WtdAvgPctGoalMet in descending order.
Dim strSQL As String
strSQL = "ALTER TABLE [table name] SORT COLUMN WtdAvgPctGoalMet Desc"
The above produces a syntax error message but gives no clue as to what should be changed. Any suggestions would be appreciated.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Overview: This article:
(a) explains one principle method to cross-reference invoice items in Quickbooks®
(b) explores the reasons one might need to cross-reference invoice items
(c) provides a sample process for creating a M…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…