Search results

Is there a way to take a yes/no field and have it be changed from yes to no, and visaversa based on the date? I have developed an sql for this, but it is not working properly, does anyone have any suggestions? Here is the sql: SELECT tblMBUSAResourceList.Active FROM tblMBUSAResourceList...

Ok, I have gotten pretty far, just a few more bigs and I should be out of everyone's hair. I am trying to count the number of yes's from a Yes/No Format. I have gotten an sql, but it is bringng back the count of the total Yes/No not just the yes's. Does anyone have any advice, the sql is...

Please Help Me.... I am trying to count the number of active contractors at the beginning of the month, and then do the same thing for the number of active contractors at the end of the month. I have their end dates and start dates enterred into a table. I would like for the count to update...

For some reason, in the query I created, the number of records is 12321. It should only be 111. The number of records seems as though it was squared. Does anyone know anything as to why this is happening?:eek:

I am new to this site, but it seems to be the place for to find what I am looking for. I am trying to use the count function in Access to count the number of Active in a field. The Active field is designated by a check box. I want to figure out how to count how many of the boxes are checked...