Recent content by dhborchardt

That will work. Thanks

I have some PCs that are logged into the local PC. The PC is in the domain but users don't authenticate. These PCs are used for accessing one IP application and nothing else except to print. I can attach a printer via the print server and that works fine for a day or two. Eventually this...

Here is what I have so far: SELECT dbo_AdmittingData.AdmitDateTime, dbo_AdmittingData.VisitID, dbo_AdmVisits.PatientID, dbo_MriPatients.Name, dbo_AdmDischarge.DischargeDateTime FROM ((dbo_AdmDischarge INNER JOIN dbo_AdmittingData ON dbo_AdmDischarge.VisitID = dbo_AdmittingData.VisitID) INNER...

I need a query that will find out how many patients were in the hospital at midnight of a given day or range of days. I have the admitDateTime and the DischargeDateTime. The format of the Admit and Discharges is '3/31/2008 12:00:00 AM'. I would like to use a parameter query and put either one...

Bingo - I guess I should have caught that. I also noticed that I posted in the wrong Forum. I must have mis-clicked. Thanks a lot for the help.

Thanks I created the extra table like so: CODE / Title ______________ 1 FTE1 2 FTE2 and changed the SQL like you showed. I didn't use the same table name. When I run it, I get a syntax error. When I click OK it highlights the JOIN word. TRANSFORM Sum(Sheet1.TotalHours) AS...

I need to change the names of the two column headings for [Primary earning code]. There are only two possibilities: 1 and 2. I would like 1 to say FTE1 and 2 to say FTE2. This is needed to interface another DB for running reports. TRANSFORM Sum(Sheet1.TotalHours) AS SumOfTotalHours SELECT...

Thanks

ONe more question if you don't mind? I looked at it and the only thing I don't understand is the last Order By line: ORDER BY 1,2; What does it do?

Thanks You nailed first try.

'Primary Earning code' is the same as 'Pay Type'. There is a third table involved to resolve the 'Primary Earning Types' down to two Pay Types. SELECT DISTINCTROW dbo_PpTimeCards.JobCode, dbo_PpTimeCardEarnings.Hours, tblEarningMnemonics.[Primary Earning Code] FROM (dbo_PpTimeCards INNER JOIN...

I am trying to add together all the hours for each job code for Two different pay types. Each employee has a job code and there can be more than one employee with the same job code. Each job code can have one or two pay types, for example 'regular hours - "Productive hours"', or 'Sick/Vacation -...

Thanks I will try that.

Thanks a bunch

Wow I have never got answers back so fast. Thanks. So if I change the cha sys cov / Forward / Call Forward Override to Yes, Will this make it happen? What are the negative consequences of doing this?