Search results

Here is my SQL SELECT tbl_CDS.[Organization Name], tbl_CDS.HRET_MeasureID, tbl_CDS.Project, tbl_CDS.[Start Date], Count(tbl_CDS.[Start Date]) AS [CountOfStart Date] FROM tbl_CDS GROUP BY tbl_CDS.[Organization Name], tbl_CDS.HRET_MeasureID, tbl_CDS.Project, tbl_CDS.[Start Date] HAVING...

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

Are you referring to the forms wizard because I only see basic types of forms and not subforms.

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

Will this work with charting?

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

Thank you, this was a simple but effective solution.

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

Here is mh SQl code SELECT tbl_CDS.[Organization Name], tbl_CDS.Project, tbl_CDS.Measure, tbl_CDS.[Data Collected], tbl_CDS.Numerator, tbl_CDS.Denominator, tbl_CDS.[Measure Rate], tbl_CDS.Timeframe, tbl_CDS.[Start Date], tbl_CDS.[End Date] FROM tbl_CDS GROUP BY tbl_CDS.[Organization Name]...

Bob, I tried what you suggested and this did not work. I have included in a report header the dropdown box. When I run the report I still get the parameter box from the Query. In the query I referenced the dropdown box. Can you assist me?