I am having a difficult time trying to establish the following query into two of the forms I have created in my Access 2010 dB. I have attempted to point to one of the forms in the 'Criteria' field to no avail.
SELECT Count(*) AS PPCount
FROM (SELECT DISTINCT [Pay Date] FROM [List Gross Pay Query]) AS [%$##@_Alias]
WHERE (((Count(*))=[Forms]![List Checks]![Pay Date]));
Can you anyone kindly assist me? Thanks in advance!