Recent content by kjohns

Thanks, vapid2323! That took care of the Run-time error. I'm now able to move to a new record in my subform without that error. In case anyone cares, my updated code for my subform is as follows: Private Sub EndTime_AfterUpdate() Me![EndTime].Tag = Me![EndTime].Value End Sub Private Sub...

I have a database for capturing OR utilization. On my main form (frmBlockEntry), I list the surgeons' OR block time (including fields StartTime and EndTime). On the subform (frmReleaseEntry), I chunks of the original block that were used, released, or given up to another surgeon, so I'll have...

I have a crosstab query (qryPhysicianLevelbyPayorMix) that references another query (qryChargeTotals for Physician) to determine what percentage of total charges were for each type of insurance. Unfortunately, this query is not producing the results I'm expecting to see. It either gives an...

I'm still working on stripping out data from my database to post it, but I'm swamped right now. However, a co-worker and I did figure out how to pull the rolling data in a field in the query, so I thought I'd post that in case it might help anyone. RollingNonBadDebtPayments: (SELECT Sum(B.[Non...

I've been playing with this more and using SQL instead of DSum. I'm getting closer using the query below. SELECT A.[Fiscal Period (CPD)], A.[Fiscal Year (CPD)], A.[Provider Name], A.[Department Name], A.Charge, (SELECT Sum(B.Charge) FROM ImportData AS B WHERE (B.[Fiscal Period (CPD)])...

Okay, I've got the Fiscal Year and Period concatenating so that they look like 200901, but I'm still struggling with the DSum. Can anyone help with the DSum statement?

Paul, That sounds like it would work as long as there's a way to force the 0 in 01 to concatenate, as the raw data pulls over without leading zeroes. If I were to do that, would I use the example that was in the cited thread and treat it like a date, in the format yyyymm? In that case...

I have read a previous thread on rolling sums using DSum (http://www.access-programmers.co.uk/forums/showthread.php?t=112221), but I am running into issues with writing the DSum query I want. Below are a few of the fields I have in table ImportData. (Note that these fields are named as they...

Re: Need to Find Patients who Exist in a Table with One Value, but Not Another Value I'm using SQL Server Enterprise Manager version 8.0.

I have a table, tblPatientDiagnosis that is a many-to-many table. It hold PatientIntakeFormIDs (unique identifier for patient) and DiagnosisIDs. Obviously, each patient can have multiple entries. I am trying to pull patients who have X diagnosis, that do NOT have an entry for a Y type of...

I have a form that calculates evaluation task due dates based on an employee's hire date. For example, for something that needs to be done 45 days in advance of the anniversary date (the employee's hire date, but in the current year), I use the expression...

Never mind - problem solved. Somehow the field was moved over as far as it could so that it was invisible, but it wasn't "hidden." Sorry for the dumb question - I guess we all have to have one at some point. ;)

I noticed this issue when I tried to create a query against the table... I have a table, tblMaternalInfo, with a field called Gravida. It's just a numeric field. I can see the field when I'm in Design View, but when I go to Form View, the field is not listed. I've tried highlighting the...

RESOLVED - Thank you jzwp22, that worked perfectly! Thank you for the explanation. The select datepart is a much easier way of doing it than trying to do between...and. Thanks for your help! Missinglinq, thanks for the watchout. The form I'm working on is in single form view, so it's not...

Hi. I'm struggling with how to set the value of my PatientName field based on the patient's referral date (ReferralDate). Both fields are on frmPatientRecordbyLName and I'm sure I'll need to use VBA code since I'll need to set the color to one of five colors and Access2000 is limited to 3...