Error in Counting
Im having a problem getting access to count the correct number of records when i run a report. The problem is that i have a subform within a main form , which records payments made to a claim account, and instead of counting the 1 record from the main form it counts the many (20 in some cases) records in the subform. i am totally stumped on this one, any help is appreciated.
PS report looks fine, with correct number of records, but when i use the count function it gives me the number of payments, not number of claims