Recent content by benesch

Hi PH and Leslie, Below are sample input, the complete SQL code, the actual result, and the desired result. Thank you for your patience with me! SAMPLE INPUT RESID ADMHOME ADMNURHOME ADMSUBACUTE 19 X 20 X 21 X 22 X 23 X 24 X 25 X 26 X 27 X 28 X 29 X 30 X 31 X...

Hi PHV, When I try your suggestion,ADMLHOME: Sum(IIf([ADMHOME]='X',1,0)) the query returns one record with a value of "YES." Andy

Hi Leslie, The SQL is as follows ADMLHOME: Count([ADMHOME]) WHERE [ADMHOME] = "X" Andy

Hi Alex, When I use the WHERE clause, I get an error message, "The expression you entered contains invalid syntax. You may have entered an operand without an operator." Andy

Hi Alex and PHV, I tried both of your suggestions: Alex when I ran the update query, no records were updated. Can I update the new field and set the values to true for each "X" in the same query? Using Count([FieldName]) doesn't work for me because it gives a count of all records in...

Hi all, Thank you for your help. Unfortunately I tried all of your suggestions, and still didn't get the result I am looking for. Perhaps I didn't make it clear. The result, which I am looking for is to count the total number of occurences of "x" for several different fields. I wish to...

Hi Alex, How would I run a query to count the number of rows with 'X' n them for multiple columns? The 'X' values may be in different rows in different columns. Below is a sample of the data: FACID ADMHOME ADMNURHOME ADMSUBACUTE NJ80A003 X NJ40A000 X NJ82462 X NJ80A110 X YMOSFX X...

Hi, I am trying to change the data type of multiple calculated fields from text to logical? Is it possible to do this in a query? Alternatively, how could I run a make-table query and have the values of these fields be set to logical each time the query is run. The reason that I wish...

Thanks to both of you. Your suggestion solved my problem.

Hi: I am using a table containing birth dates of assisted living facility residents. I calculate each person's age using a query. The result is calculated out to 13 decimal places. I need to calculate the number of residents whose age falls into specified ranges: <60, >= 60 and < 65...

Hi: I am responsible for producing a spreadsheet showing the number of Assisted Living Facilities by county that have been completed, are pending approval, or are under construction, and the corresponding number of beds. This information is updated four times a year. I am currently doing...

Hi: I am responsible for producing a spreadsheet showing the number of Assisted Living Facilities by county that have been completed, are pending approval, or are under construction, and the corresponding number of beds. This information is updated four times a year. I am currently doing...

I have designed a form, the purpose of which is to select long-term care facilities by category. This form contains the following objects: 1) An unbound combo box used to select facilities by name. As the form stands at present, all facilities appear in this combo box, sorted alphabetically...

Hi: In the near future I will be receiving survey forms that will be available on our organization's web site in .dot (MS Word template) and .pdf formats. The persons filling out the forms will E-mail them to me in one of these formats. I will need to convert the data that I receive into an...

I am trying to generate a list of Nursing Homes, including the number of licensed beds in each facility. In many cases there are different types of beds within a facility (e.g. Long term care, residential, ventilator). How would I suppress printing of the label (bed type description), if that...