Search results for query: *

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?

I have an ext (564), that will cover to another ext (525) if nobody picks it up. If nobody picks it up at 525, it should cover to 525's voice mail. This is not happening. If I call 525 directly, and nobody answers, it works fine. I am using a coverage path for 564 that redirects it to 525.

I am building a form that will be sent off in email. I have the CDO part figured out and I have but one field left to populate with the email names from our exchange server. I need to figure out the LDAP path to get the EMail names. Here is what I have so far that does work. I would like to be...

I need to move a bunch of home folders from one 2000 server to another. Is there an easy way to do this and keep the rights.

Thank you for you reply. I have two follow up questions. In your solution, did you intend this to be a query on its own, or do I add this SQL to the existing. I don't understand what PK_of_tblPM is Thanks again Dale

I have a query that will look at the PM table and see when the last PM was done, compare it with the PM recurance number, and if it is greater than the PM occurance number, the datediff will be set to yes and will then appear in the result. This is what I would like to do. If DateDiff is set...