Count or summary of fields

[Greenkat5]

I am new to using report writer and have been dropped somewhat in at the deep end so any help will be appreciated !!____1)How do i create a count of a field when I select it from a database?____2)Also how do I change a date format from xxxxxxxx in the database to display just the month e.g January in my report?

[kfleming]

>1)How do i create a count of a field when I select it from a __>database? __Use Calculations Total Field, enter a field name,select count as the total type and select the field you want to count from the field list. Then select the reset level (use grand if you want a total for the entire report)__and then place the total on a summary band (for a grand total)____>2)Also how do I change a date format from xxxxxxxx in the __>database to display just the month e.g January in my report? ____Create a calculated field with the expression CMONTH(datefield) where datefield is the field name that you want to display and then place this calculated field on the report layout.____Kathleen__R&R Support

[Martin_Young_(Guest)]

Thanks for the help. However the field i am trying to count is a text field and this does not seem possible??____The date formulai worked a treat though____Mart

[Greenkat5]

Sorry was not logged in when i wrote that____Martin

[kfleming]

Count is available for character fields. It returns a 1 if the field has a value and a 0 if it is empty.____Kathleen__R&R Support

[Greenkat5]

in my report i want to create a table of attendance at our health and safety centres by month.____The Date field is in xxxxxxxx format and i need the report to count the number of visits to each department within the centre.______ Nurse Optitian Chiroposist__January 5 45 10__February 6 45 76__March 34 6 45____Hopefully to return something like the above? where the numbers relate to ammount of attendance.__