Search results

I have a form that I use a filter on to make my where statement for the query I have. The form has 3 drop downs: County, City, and State. Everything works great except when you only choose a state you should get the totals for just the state and instead you get a report by city. Here is my sql...

After reading some of what people already had in this forum, I was still left a little confused. Say I have a form with three combo boxes and I want the user to be able to select something from all 3 or just one at a time. Which kind of query should I be using. Right now I have a select query...

Here is my sql statement that I want to get the total number of "yes" in each field. Each field is a text field. SELECT Sum(Homeless="yes")*-1 AS HomelessCnt, Sum(NFresident="yes")*-1 AS NFresidentCnt, Sum(Self="yes")*-1 AS SelfCnt, Sum(StaffBoard="yes")*-1 AS StaffBoardCnt...

In my report I have an unbound textbox with Control Source =DSum("[Homeless]","ReportCountyQuery","[Homeless]='yes'") homeless is a field in ReportCountyQuery and is a text field with yes/no in it. Can anyone tell me why I am getting #error in my textbox. Thanks. Bobby

With using the following sql statement, is it possible to do more than one field at a time? SELECT Count(*) AS CountYes FROM (SELECT tblYesNo.fldYN FROM tblYesNo WHERE tblYesNo.fldYN=Yes); Thanks Bobby

I have a query in which I have many text fields that contain yes/no. This is the only way I could get the yes/no out of excel. I want to be able to count these fields getting the count of yes only answers. I have tried adding different criteria and none of it seems to work. Any help would be...

I have a report that is generated from a query based on Combo Box entries. In the report there is a county, city and state which they are filtering on. I was wondering how I can get it so that each city only appears once so I can total by city. Right now each city shows up as many times as it is...

I have a form with three combo boxes. After a selection is made in the combo box a query is run that creates a table of the information needed. The next two just refine the data a little. I want it so if they only use one or two of the combo boxes I send the right table name to use for the...

I have 3 combo boxes on my form and I am trying to update the second by the choice made on the first. I have a query for each box that when a selection is made it makes a table of information I use in the next box, and after I select something from the first box I get this error, but it does...

I have a form with three combo boxes and am looking to open a report based on the choices they make. After each combo box is selected a query is run that makes a table based on their choice. I want to be able to use the appropriate table, without having to set it each time. The data displayed is...