Search results

I am in the report footer of my rptCountryTotal report and need to access the total number of records in my qryDistinctCountry query. I have been wrestling with variation of Count(*) but cannot get the correct syntax. Am I on the right track or is there an easy way? I am a novice at ACCESS and...

I have a database of 22,000+ entries and have used three queries 1. Sort coins – listing all 22,000 coin and is the basis for most of my report which summarises and totals all entries for each of 536 groups (Eras) 2. Types distinct – using the coding SELECT DISTINCT [SORT COINS Query].COUNTRY...