Search results

Brian Thanks for the tip (it was knowing to use Dcount and not count(*) which was haelpful). Alt-f11 takes me into visual basic which I have not experimented with yet. F1 gives me online help which hopefully will enable me to progress without having to post on the forum Roy

Brian - when I enter =count(*) it gives the numer of records from rptCountryTotal and I want the number of records in qryDistinctCountry I am not sure of the syntax and get syntax errors when entering =Dcount FROM "[qryDistinctCountry]" Husan I have entered SELECT Count(*) AS TotalRecs...

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...