Search results

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

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

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?

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

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

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?

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.

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

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?

I want to create a query that will count the number of data submittions over a set time frame. I have a table with organization name, measure id, start date and the data. I created a query to count start date for the date range 5/1/12-8/30/12. I only get a single count for each. Does this...

I would like to create a query that shows unmatched records. I am using two files. File one contains hospital name with a checkmark for eacf of 10 quality initiatives they are working on. The second file is a data dump from the govt. It shows who entered data. I have a hopsital ID in...

I am trying to create a form where you select an orgnaization at the top of the form and then all the tabs displays that orgnaizations information. For example the tabs would include contact history, reports, demographic information. How can I make this happen? DO I need to use a set of...

I have built a search form using the VBA code below. The problem is the search fucntion requires only returns a search for complete answers. Example if I have Steve Smith and seach for either Steve or Smith I get no results. When I include the entire name it finds a match. How can I write...

My end goal is to create a form with a line chart. A person would select the organization and then the data indicator. I thought by creating two queries, one with organization name and the other with the data indicator fields. I had thought if you selected organization first, I would only...

I am new to Access and have little experience with VBA. Each month I receive a flat file of data from 265 teams. I need to make sure each team enters data each month. If a team does not enter data, then it is not in the flat file for the month. How can I create a report to identify missing data.

It has been a while since I used Access and I have no programming skills. I have a desgined a form that can be used to record whether an organization offers particular sporrts. ON the form I have a dopdown with the organization name and 10 check boxes with sports next to each one. All is in...

Good afternoon. I have a database with 3 tables. Table 1 conatains organization name and CMS_ID number. Table 2 only contains organization name and no primary key. I am trying to create a new field in the Table 2 with the CMS_ID from Table 1. Is this possible. In short I need to create a...