I am having trouble performing a count feature.
I have 2 tables, one with property detials, another with proeprty viewings - each time a property has a viewing a new property id field is created adds information re the viewing.
I want to count each viewing for a property.
Now the select feature does not work as it is a grand total and only lets me insert to the footer etc and not in the main section.
The running total just counts ie: 1,2,3,4,5,6,7,8,9 etc - this does not count each viewing for a property
I used a foruma: Count () but this counted all of the records in the viewing table and not vieiwngs PER property.
Please can I have help ?