T
tina
i modeled your setup, as
table CustomerPhoneNumbers
CustomerPhoneNumber
table PhoneCalls
PhoneNumber
NumberOfCalls
here's a SQL statement that should work, after you put in
the correct table and field names from your db:
SELECT CustomerPhoneNumbers.CustPhoneNumber, Nz
([NumberOfCalls],0) AS CallCount
FROM CustomerPhoneNumbers LEFT JOIN PhoneCalls ON
CustomerPhoneNumbers.CustPhoneNumber =
PhoneCalls.PhoneNumber;
hth
table CustomerPhoneNumbers
CustomerPhoneNumber
table PhoneCalls
PhoneNumber
NumberOfCalls
here's a SQL statement that should work, after you put in
the correct table and field names from your db:
SELECT CustomerPhoneNumbers.CustPhoneNumber, Nz
([NumberOfCalls],0) AS CallCount
FROM CustomerPhoneNumbers LEFT JOIN PhoneCalls ON
CustomerPhoneNumbers.CustPhoneNumber =
PhoneCalls.PhoneNumber;
hth