custom message based on query results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a query to check for duplicates as the following:
SELECT [ALL Policies].CustomerNo, [ALL Policies].ApplicationNo, [ALL
Policies].Carrier
FROM [Working Table] INNER JOIN [ALL Policies] ON ([Working
Table].ApplicationNo = [ALL Policies].ApplicationNo) AND ([Working
Table].CustomerNo = [ALL Policies].CustomerNo) AND ([Working Table].Carrier =
[ALL Policies].Carrier)
GROUP BY [ALL Policies].CustomerNo, [ALL Policies].ApplicationNo, [ALL
Policies].Carrier
HAVING ((([ALL Policies].CustomerNo) Is Not Null) AND (([ALL
Policies].ApplicationNo) Is Not Null) AND (([ALL Policies].Carrier) Is Not
Null));

I would like to send the user a custom message based on query results.
Anyone have any suggestions?
 
Using a form, run the query in the Click event of a command button and
display messages depending on what the query returns.

Carl Rapson
 
Back
Top