I want to add the number of unique records in the report footer. Can I count the number of unique records using Count and Select Distinct? I cannot seem to make it work. Any help would be appreciated.

=Count (Select Distinct [Name])

=Count(*) counts the records in the form's recordset. If you want to use a different domain, you need to use a DCount().