I icemac Registered User. Local time Yesterday, 20:03 Joined Jul 17, 2006 Messages 31 Aug 8, 2006 #1 In the query if i am doing a 'count' it does not work if i enter any criteria. It works fine if there is not criteria (search)
In the query if i am doing a 'count' it does not work if i enter any criteria. It works fine if there is not criteria (search)
Brianwarnock Retired Local time Today, 04:03 Joined Jun 2, 2003 Messages 12,701 Aug 8, 2006 #2 Enter the field twice into the query grid Count the first make the 2nd a Where and enter the criteria below Brian
Enter the field twice into the query grid Count the first make the 2nd a Where and enter the criteria below Brian