Dcount Records

  • Thread starter Thread starter Jean
  • Start date Start date
J

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
 
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
Click to expand...

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]);
 
Jean said:
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
Click to expand...

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