Search results

  1. C

    Create a Top N Values per Group Query

    Yes there was and after removing the underscore I was able to get the example to work in the Northwinds database. Using the same logic I applied the fields from my database. The end result is I keep getting asked to enter a value for HRET_OrganizationID
  2. C

    Create a Top N Values per Group Query

    Paul, thank you for the response. I have reviewed this article and I am still unable to get the results I am looking for. I even tried not using a query but the actual tables and no luck.
  3. C

    Create a Top N Values per Group Query

    I am looking for some assistance in desinging a query that returns the top 4 records for each group. I have a base query that includes HRET_OrganizationID, HRET_MEasureID, Start Date, Numerator, Denominator, and Organization Name. This query serves to pull out the records I am interested in...
  4. C

    Update Query with Criteria

    Close but here is the actual syntax [MeasurementStartDate]="12/1/2012"
  5. C

    Update Query with Criteria

    I used to know this, but have forgotten it. I want to create an update query to change admissions to zero for the month of December. I am getting stuck in the criteria. My table has the following CMSID, Admission, StartDate I enter startdate =12/01/12 in the criteria and it will not work...
  6. C

    Select last 3 months worth of data

    What is I want the top 3 dates and the corresponding data for these dates?:banghead:
  7. C

    Select last 3 months worth of data

    Can I run this without the organization name? Lets pretend we are only doing this for a single organization. What modifications would I make to the code?
  8. C

    Select last 3 months worth of data

    Brian, I added the code you provided by listing it as the criteria in query under the start_date field. This is the error message I received syntax error "missing operator) in query expression 'Organization Name='Alton"
  9. C

    Select last 3 months worth of data

    Brian, thank you for the example. The only trouble I am having with the example is where to put the line of code? Do I create a new variable in the query and add to the critieria line or do I add it to the date field? Is the reference table1 supposed to the table name. The fields I would...
  10. C

    Select last 3 months worth of data

    I have uploaded the results of a cross tabs query. The field names in my query are OrganizationN Name, Medicare Number, Project, HRET_MeasureID, Time, and Measurement Rate. If you open the attached file and look at the last 3 data points you will see that not all organization have data for all...
  11. C

    Select last 3 months worth of data

    I need to create a query that pulls only the last 3 months of data from the previous 24 months. My challenge is that not all the ending dates are the same. For example Org 1 has data ending Jan 31, 2013 while Org 2 has data ending Sept. 2012. Any suggestions?
  12. C

    Form with multiple tabs loads very slow

    I have created a form for my supervisor so she can see all the pertinent information related to her hosptial accounts. (See attachment) The challenge I am having is the form takes a while to load. All of the tabs are build on different queries. Does anyone have some advice on how to speed up...
  13. C

    IIF then and conditional statements in queries.

    JDraw, thank you for your reponse. How is my question out of context? I already have a large database with all the data I am looking for. My boss would like me to create a scorecard for each hospital. We collect data on ten topics. For each of these ten topics hospitals have up to 8...
  14. C

    IIF then and conditional statements in queries.

    I am looking for assistance in creating a query. I am creating some hospital score cards and one indicator is falls. There are 95 hospitals that I need to create score cards for and they can choose up to 10 measures for falls. I want to create a query that essentailly picks which fall measure is...
  15. C

    Change Text Color based on Value

    I have a report and want to set the value for positve numbers to be displayed in red and negative numbers in green font. How can I accomplish this?
  16. C

    Decimal places for created fields in a query

    Good afternoon, I have three quiries with calculated fields in each query. Is there a way to adjsut the decimal places. For example when I calculate a rate here is the result 4.92853622474125E-04. As you can seee this is too long and is in scientific notation.
  17. C

    Beeping error on Combo Box

    I have a form with a subform. I added a combo box to the subform that list out the staff names. When I go to the form view I can activate the drop down but get an annoying beep when I try to click on a staff name. I have a simar form with the staff information and it works. I do not see...
  18. C

    Data Entery when form in Data view

    I have created a sub form that is displayed in data view. I have combo boxes and free text fields. I can enterd data like the data and save. I am unable to use the drop downs menus created from my combo box. Why is this and how can I fix it?
  19. C

    Counting in a query

    Paul, is there an easy way to replace the counts with the dates and all be in one row?
  20. C

    Counting in a query

    Paul, thank you very much. After comparing the SQL, I see where I made my mistakes. This will be very helpfuil in the future.
Back
Top Bottom