countif function no clue

[juriemagic]

Hi good people!,

If you have time and patience, then I beg you for your help. I am trying to set up a query that would countif how many zeros are in a column. The field name is TV and there are 21 records in this field, ranging from 0 to 2. I am learning queries now and I do know that you enter query design view. I have fiddled somewhat with the fields at the bottom but I obviously don't know what I'm doing. Since this morning I have searched, found some answers, but all answers were given in a much higher than basic way, meaning the people involved knew what was being said and meant. Please, I need step by step "how and what to do" instructions. Please, I am at my wits end..

[ranman256]

Select count([tv]) from table where [tv] = 0

[juriemagic]

Thank you, what do I do with this info?...where do I go?..As I have explained, I know less than nothing when it comes to calculations in Acess. Please guide me if you don't mind?

[CJ_London]

copy ranman's code then in the query design window, click on the SQL button option top left - then paste ranman's code. Note you will need to change the word 'table' to the name of the table which has the field 'tv'. If the table name has spaces you will need to use square brackets e.g. [table name]

[juriemagic]

okay, thanx for the info...uhm, I don't know what to say, I'm just plain stupid I suppose. I do not see an SQL button anywhere, don't know what it looks like...and so I can go on. Ajax, I appreciate your time, but it's okay. I have decided I am not going to waste you guys time anymore on me and my stupidity. I'll just google stuff that I want to know, see if I can do some crash courses, and if it takes me a year to do just a simple sum calculation, then so be it. Really, don't worry about this anymore. Thanx again..

[CJ_London]

click on the downarrow here


Sounds like it would be a good idea for you to buy a book or find some youtube examples to get the basics

[juriemagic]

haha, absolutely. Anyways, I have made a breakthrough!!!...yippeeeee!!!..I found the SQL button, pasted the code and it works great!...Thanx again!

[CJ_London]

it's all progress!