![]() These examples show how you could use ECount() in the Immediate Window (Ctrl+G) in the Northwind database: Expression Use square brackets around your field/table name if it contains a space or other strange character, or starts with a number. You can then use the function anywhere you can use DCount(), such as in the Control Source of a text box on a form or report. To verify Access understands it, choose Compile from the Debug menu (in the code window.) In Access 2000 or 2002, you may need to add a reference to the DAO library. Paste the code below into a standard module. ![]() The other arguments are the same as DCount(). ![]() The domain aggregate functions in Access are also quite inefficient.ĮCount() offers an extra argument so you can count distinct values. The built-in function - DCount() - cannot count the number of distinct values. Microsoft Access tips: Extended DCount() Microsoft Access Tips for Serious Users
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |