Help with COUNTIFS Totaling Text Fields in an UPDATE QUERY

[SealM]

I haven't found a good source for this information, so I thought I would ask here. I have a list of text boxes that may contain text, or may not. I just want a number field that totals the text boxes that have text in them and give a count.

For instance, I have the text fields text1,text1, and text3. And a number field called textboxcount

If there is text in text1 and text3, then textboxcount would = 2

Any help would be appreciated! Thanks!

[orange]

COUNTIF is not an Access command or native function.

Can you provide more info about your database, tables,form?

[SealM]

Sure thing. This is for ONE table. There are actually 6 text fields that have various text in them (or they can be blank) There's actually text in them when a flagged item appears.. this detail is not really important, but basically all I want to do is make a count of all the "flags" that appear in each record. And a flag is made by there being text in one of these boxes.

In excel, it was no big deal, but here in Access, I don't know what the SQL would be to sum the text fields that have text in them.

[SealM]

Okay, I found the solution I needed. I was thinking too hard about this obviously. But it brings up another problem I have, which someone may help with. I just updated the count by using a WHERE statement. Now, I since I have 6 text boxes that COULD have data in them, I have to make a query that updates the count for each one. Can someone tell me a way to combine these two queries?

Here's the first one, which just puts a 1 in the [total.flags] field if there is the specified text in the first field:
UPDATE Raw SET Raw.total_flags = 1
WHERE [call_on_weekend]="Call on Weekend, ";

Now, here's the second one I created, which adds 1 if the 2nd box has the specified text in it:
UPDATE Raw SET Raw.total_flags = total_flags+1
WHERE [call_after_6pm]="Call after 6PM,";

They both work great, but I would LOOOOVE to combine these two queries so that one query would do both. If I can do this, then I can add the other 4 in here, and make it do what I had originally wanted to do in the first place! Yay! hehe