Search results

Is there a way to only count unique values. There are duplicates and I only want them counted as 1.

Let's pretend I'm brand new to access. I don't have a subform in my request for help. I have a query and a report. Where would I put the above suggestion?

I have created a database that has 3 tables with the Client name being the connecting relationship. I created a query to filter out certain information from these tables. The tables are: Green Book, Yellow Book, and White Book/Debtors I need to count the # of debtors for each client...