![]() ![]() If you prefer to export using VBA code, use the DoCmd.TransferSpreadsheet function, which is well documented in the Access help. If you are looking for a result like the example above, then just select the export function from the File menu while you have the query highlighted in the Database Window and export as an Excel spreadsheet. The second column would be the number of entries (rows) for each vendor in this example. If you add the sum column you could get results like: (You can also impose conditions by selecting Where from the drop down list and entering conditions in the criteria row.) Change the Total row for the additional column to Sum (select it from the drop down list). If you also need to know how many or your original records match each distinct column/s then add an additional column to the query (you can use one of the columns already used if you want). If you run this query you will see one record for each distinct occurence of the column(s) you selected. A new row titled Total will appear in the query builder grid and it will say "group by". The easiest way is to use the Access query builder to build a query with the one column (or combination of columns) that you want counted, but thenright click in the sort row and select Totals. HI, i am using Access 2000 i have report in Access (Billing) which i need to send to my clients on weekly basis to get back my money, i t consists following. ![]() I would suggest building a grouping query and then using the count function on the grouping query.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |