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.
Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…