Records Count

  • Thread starter Thread starter Daud Akbar
  • Start date Start date
D

Daud Akbar

This is all about counting column data in report:
If i have a text data how can I count it.
how can i count specific records in a column say I have a
shift column that carries morning afternoon and evening
shifts. now i wana count it seperately in a sense that it
counts only morning shift.
If i have again a shift column that have 1 and 2 shifts
how can i count them.

plz help me out of this problem.
 
You could create a query to GROUP BY the Shift field, and COUNT the primary
key. In query design view, depress the Totals toolbar button, and follow
your nose from there. If the results are to go into the Report Footer area,
you could use a subreport to display them.

Alternatively, if there are only two, you could just use a text box with
Control Source of:
=DCount("*", "MyTable", "Shift = 1")
 
In any Group or Report footer, you can use:
=Abs( Sum( [Shift]="1" ) )
=Abs( Sum( [Shift]="2" ) )
This assumes Shift is a text field as you suggested.
 
Back
Top