Search results

I have not done a lot of programming in Access over the past two years. I can remember getting this error, but can't seem to remember how to deal with it. This is a very simple update query which uses two local tables. The 'many' table (tblCleanedRxData) has a primary key. I looked at some an...

I have a table of patients (one) and a table of vital statistics (many). I need to get a list of the patients whose values of the last 2 readings in the year are over a certain value. Both of the last 2 need to be over a cretain threshold for the patient to be counted. I can group on Patient_ID...

This is very odd. We have a dozens of Access databases at work. Most use the same start-up form which is copied in to every database. It allows the user to select a SQL server and then tables are re-linked accordingly. In one Access database the form opens full-screen and then all subsequent...

Table tblReportPatients has 23 PatientIds in it. tblDemographic has a 1 to many relationship and is filled with demographics values for each patient ID. A patient could have multiple "Grade Completed" rows in tblDemographic and each one has an EncounterDate when it was recorded. The query below...

I'm joining 2 tables that have a one to many relationship. I have a field named ClaimNo that I join on. The criteria for selecting records is on 2 fields on the many side. I only want to get a count of the unique ClaimNo. However, because on the many table I return multiples of claim no the...

I have a report with a chart as a subreport. The data for the chart is stored in a table where each PersonID has 4 rows. This PersonID is the link field that ties the subreport to the main report. The main report data is drawn from a different table. Each row in the subreport table has a value...

Here's the query... SELECT tblSJHSVendorCount.MembID, tblSJHSVendorCount.Vendor, (SELECT TOP 1 VendCount2.CountOfVendor FROM tblSJHSVendorCount AS VendCount2 WHERE tblSJHSVendorCount.MembID = VendCount2.MembID ORDER BY VendCount2.CountOfVendor DESC, Counter) AS...

This is not homework, I actually do this for a living, but I'm having brain freeze on this one and I'm swamped with work right now. The code below will create a table with sample data. The data is for a group of patients. There is a table that has dozens of lab tests for the patients. Dozens...

It is not really 1.74 million records, but Access thinks it is, for some reason. Here's what happens: I get a CSV file in with 2196 lines. There are 2 date fields that are formatted poorly. Sometimes it is mddyyyy and some times it is mmddyyyy. I import the data to one table and then export...

This is a many table of Chart numbers and labs. Each lab has a lab date and a lab value. There are 65 different labs and some chart numbers may have multiples of each, while others may only have one each of 6 or 7 labs. What I’m trying to get are the 3 most recent dates of each lab for each...

Does anyone use any third party data bound controls they like. Years ago, in VB, I used a data bound grid control called something like TurboGrid. I'm looking for a collection of data bound controls that go above and beyond what Access has. Any ideas?

I fell back on my VB programming once again, but I’m sure there is an easier way to handle this in Access. So here is the deal. I have a table with 15 or so fields in it. I need the user to on occasion add another row to the table. Nine of the fields are required but the rest can be left blank...