merge total number of records with grouped data in Access

[Guest]

I have a table of Potential customers which were the subject of a mailshot.
I join this table to Current Customers to show how many potential customers
responded to the mailshot by placing an order. I want to include in this
data, in each row, the total number of records in the table of Potential
Customers. Is this possible?

 

[Smartin]

I have a table of Potential customers which were the subject of a mailshot.
I join this table to Current Customers to show how many potential customers
responded to the mailshot by placing an order. I want to include in this
data, in each row, the total number of records in the table of Potential
Customers. Is this possible?

Perhaps a subquery.

SELECT
blah blah blah,
(SELECT Count(*) FROM PotentialCust)
FROM CurrentCust;

 

[Allen Browne]

Smartin has suggested a subquery.
If you want to read further on this technique, this recent article might
help:
Subquery basics - What subqueries are; 5 examples of why you want them
at:
http://allenbrowne.com/subquery-01.html

 

[Smartin]

Smartin has suggested a subquery.
If you want to read further on this technique, this recent article might
help:
Subquery basics - What subqueries are; 5 examples of why you want them
at:
http://allenbrowne.com/subquery-01.html

Allen, thanks again for the terrific reference material!