count data on a report

[hullstorage]

on my report i have say 10 records per sheet of mixed garden sets
6ft table 8ft table 10ft table

how can i count these so say there are 4 8ft tables at bottom of report it show 8ft tables=4

thanks in advance
simon

 

[statsman]

In your report footer, place a blank text box from the toolbar.

In the caption place "8 ft. tables =" (don't enter quotes)

In the text box enter "Count([tables]=8ft)" or whatever the field name is that contains the 8 ft. tables.
Example: if your field name is PartNo and the 8 ft. tables are coded as XE5TY8ft you would enter
Count([PartNo]=XE5TY8ft)

 

[hullstorage]

thanks worked a treat
had to enter = before the count and put 8ft in brackets

cheers this has baffeled me for ages