Counting a word in Access report

[rickes]

I made a report in access which gives me a running report of what type of vacation one of my employees took after I have entered them into a form. Whether or not it was a Floating Holiday, Vacation Day ect. At the bottom of the report, I have an unbound text box with the label saying "Total Vacation Days Used". what is the formula to put in the text box to total the number of "Vacation days" used in that report? In a table where the form is bound to, I have colums called, "Name", "Date", "Type of Vacation", "hours requested". Then from there in a query, I filter the information by name and make a report from there. How do I count a peticular word in a column.

 

[Eupher]

Hi, rickes,

Have a look at the DCount() function.

Ken S.

 

[PHV]

count a peticular word in a column
=Sum(IIf([field name]="peticular word", 1, 0))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886