Search results

Thanks for your help, I'll give it a try.

The only problem with that is that I would need to make a report and query for every different combination. I was hoping to do this through one query and one report.

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...

Doing it this way I will end up with 5 Queries(The county Combo populates and selects the State). Isn't there any other way of doing this with just one query?

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...

Thanks for the comment. I ended up getting it to work using Sum(IIF([fieldname]="yes",1,0)) as QueryFieldName. Thanks again Bobby

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...

Thanks Pat, actually I just moved the DSum into my Query and it works great except that I am getting the sum for as many records as there are. If you know how I could fix that I would greatly appreciate it. Thanks. Bobby

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

Also in the print preview area there is a setup button by the close button, on the tab marked columns if you uncheck the same as detail marker it will allow you to set the page size. Good luck. Bobby

Thanks for the sample. I still haven't gotten mine to work, and I even started over and went through the wizard. I will keep trying. Thank you for all your help. 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...

Still not working. I still get the city for every instance of the county. Here is my Sql statement from my query. SELECT DISTINCT PersonalInfo.Homeless, PersonalInfo.NFresident, PersonalInfo.MinSpent, PersonalInfo.CallerAge, PersonalInfo.Self, PersonalInfo.StaffBoard, PersonalInfo.FamilyFriend...

The Grouping didn't work. I need to collect all the info to count the number of items in each field, but only want to display the county, city, and state at the top of the report once. Instead I get a page for each County,City State entry. Is there anyway of passing those individual values...

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...

Thanks for the help it works great! :) Appreciate everything. Bobby

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...

Got this problem fixed, some code I didn't need in a bad place. Don't mind me, just a newbie at Access. Thanks. Bobby

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...