SYSXPERTS - Counting records by a date field in Access

SYSXPERTS
« Counting records by a date field in Access »

Welcome Guest. Please Login or Register.
Nov 22^nd, 2009, 11:35pm

SYSXPERTS

SQL General

SQL Statements (Moderator: Paul Valentino)

Counting records by a date field in Access

« Previous Topic | Next Topic »

Pages: 1

Author

Topic: Counting records by a date field in Access (Read 68 times)

Paul Valentino
Administrator

member is offline
Avatar

Gender:

Posts: 46

Counting records by a date field in Access
« Thread started on: Oct 20^th, 2006, 10:15am »

SELECT bec3_manual_list.[Date Scanned], Count(bec3_manual_list.File) AS CountOfFile
FROM bec3_manual_list
GROUP BY bec3_manual_list.[Date Scanned];

Logged

Paul Valentino
Administrator

member is offline
Avatar

Gender:

Posts: 46

Re: Counting records by a date field in Access
« Reply #1 on: Oct 20^th, 2006, 10:34am »

Or to specify only records that have no null values

SELECT bec3_manual_list.[Date Scanned], Count(bec3_manual_list.File) AS [No Of Books]
FROM bec3_manual_list
GROUP BY bec3_manual_list.[Date Scanned]
HAVING (((bec3_manual_list.[Date Scanned]) Is Not Null) AND ((Count(bec3_manual_list.File)) Is Not Null));

Logged

Pages: 1


« Previous Topic \| Next Topic »

About Us Packages Services Solutions