Recent content by foxtrot123

Plog - That worked perfect. Thanks much!

I have a table, tblVisits, holding patient's pre and post surgery visits: PatientID VisitDate 1 1/5/12 1 3/10/12 1 9/1/13 2 ...And another table holding patient's surgeries (each patient will have only one surgery) PatientID SurgeryDate 1 4/1/12 2 ... I need...

Got it! Use a total query with Group By for PatientID, Min for VisitDate, First for any other variables needed, like Complaint, and Where for TestPos. SELECT TestTable.PatientID, Min(TestTable.VisitDate) AS MinOfVisitDate, First(TestTable.Complaint) AS FirstOfComplaint FROM TestTable WHERE...

I have a table like so: PatientID VisitDate Complaint TestPos 1 4/5/2003 Coughing 1 1 1/2/2007 Sneezing 1 5/1/2008 Unknown 1 2 2/1/1988 Unknown 2 4/2/1988 Unknown 1I'd like to extract just one TestPos record (TestPos = 1) per...

I have data like: SubjectID VisitID VisitNum VisitDate VisitDetail Rspns 1 5 1 2/10/2001 Fever_1 Yes 1 5 1 2/10/2001 Age_1 12 2 7 1 5/08/2010 Fever_1 No 2 7 1 5/08/2010 Age_1 18 2...

Thank you. This did the trick.

Hmm ... each row has several variables that make each row unique. I left them out just to save space. It's typical normalized data, so something like: SubjectID VisitID Question Response 1 5 Fever Yes 1 5 Age 12 2 7 Fever No 2...

I have data like so: SubjectID VisitID 1 5 1 5 2 7 2 7 2 9 2 9 etcAnd need to return a running count for the number of visits per subject, so: SubjectID VisitID VisitCount 1 5 1 1 5 1 2 7 1 2 7 1 2 9 2 2 9 2 etc.I'd like to use DCount and...

I realize the table structure departs from normal form, but these are temporary tables that are created through a bunch of routines designed to create separate tables for use in statistical software. A dynamic query in VBA is exactly what I'm trying to figure out. Below is the very rusty code...

I use the following code to delete from a table all records except those meeting the WHERE criteria: DELETE tblABC.*, tblABC.SubjectID FROM tblABC WHERE (((tblABC.SubjectID)<>99 And (tblABC.SubjectID)<>432));I'd like to run this exact same query, but on many other tables, all of which are...

That was it! Thank you.

For the life of me I cannot get the correct syntax for this. The punctuation for the second where condition is incorrect. Any suggestions? Me.cboDose.RowSource = "SELECT Label FROM tblLookup WHERE tblLookup.[Med]='" & Me.cboMed & "'" AND tblLookup.[Notes] = "Swallowed"

And as for the underlying table structure, four separate tables - one for each type of medication? For example: tblSwallowed -------------- MedicationID MedicationName Dose DoseOther tblOral -------------- MedicationID MedicationName Dose DoseDuration WhenPrescribed WhatIsItFor etc.

I need to create a database that collects, among other things, medications (with dose information) for patients. Attached is a screenshot of the form currently being used to collect the medication data. The client would like the database interface to reflect the form layout as much as...

I asked 18 people to each sort 100 statements into piles based on the similarity of the statements. The results are arranged as below. For example: - Bob sorted statements 1, 3, and 100 into the same pile (Pile ID = 5), and statements 2 and 4 into the same pile (Pile ID = 2). - Mary sorted...