Dcount Records

[Jean]

Is their a way to count records in a qry.

So if the qry generates 50 records have a field say 50
based on the change of the month.

So you would have

Month Count records
Jan 50
Feb 40
MAR 30

 

[fredg]

Is their a way to count records in a qry.

So if the qry generates 50 records have a field say 50
based on the change of the month.

So you would have

Month Count records
Jan 50
Feb 40
MAR 30

SELECT Format([ADate],"mmm") AS Exp, Count(Format([ADate],"mmm")) AS
exp2
FROM YourTable
GROUP BY Format([ADate],"mmm"), Month([ADate])
ORDER BY Month([ADate]);

 

[MGFoster]

Is their a way to count records in a qry.

So if the qry generates 50 records have a field say 50
based on the change of the month.

So you would have

Month Count records
Jan 50
Feb 40
MAR 30

SELECT Month_column, Count(*)
FROM TableName
GROUP BY Month_column