Count function in Access...help

[ryanpch]

Hey,

Not sure if I'm in the right Forum, but here it goes. I thought I knew what I was doing apparently not. I want to count the number of times a 'word' appears in a column. Let's say I have a table called "January1", a column called "ItemCategory". I want to 'count' the number of times 'word1' and 'word2' appears, and total them at the bottom of the table/report.

Is this on the right track?...=COUNT([ItemCategory])

Thanks in advance.

 

[RiverGuy]

No, you have the incorrect forum. Look at the top of the web page. There is a textbox followed by a drop-down which should say "Find A Forum." In the textbox, type "Access", and then click the Search button to the right. It should pull up a list of Access related forums.