Search results

I work in a hospital outpatient clinic. Fields are: Clinic name: Doctor name: Appointment status: <-- this could be ARR, CXL, BMP, NOS, PEN, or RSC DUR: <-- duration in minutes (such as 20, 40, 60, 90, 120) My provider footer counts the number of occurances for each appointment status. I...

I am trying to determine the top 20% medications used in each clinic at a hospital. How can I create a query and or report to show me only the top 20% (per clinic)? Example of entry: Medication Clinic Totals FAMOTIDINE 20 MG TAB NGI 8 LANOXIN 0.25 MG TAB NGI 2...

I apologize... I have no idea what you mean. The DateDiff formula is: ApptArvl: DateDiff("n",[APPT],[ARVL]) The results is the number of minutes between arrival and actual appointment time (negative numbers indicate the number of minutes early). I would like for the user to filter and show...

input fields: DATE 12/25/2004 APPT 12:05 pm ARVL 12:10 pm APPTARVL is a calculation of the difference in minutes: ApptArvl: DateDiff("n",[APPT],[ARVL]) The query will be used for reporting purposes... When the query is opened, the user is asked for a date range: Between [START DATE] And...

For the purpose of creating a report, the user is prompted to enter his criteria. I would like (within my query) to create a prompt that allows the user to say, "Show me all data with less than 5 units." So, in my criteria what do I put??? I would guess: [ENTER < AND UNIT] so the user enters...

Yes, my typo... GOAL: DateAdd("n",30,[ARRIVAL]) However, I am hoping for the result to show the minutes in difference between the two. For example: ARRIVAL was at 2:00PM GOAL would be 2:30PM PHYSICIAN saw the patient at 2:25PM The RESULT should show -5 since the physician began seeing the...

I have three time fields. Field 1 displays the time of the patient's arrival. ARRIVAL The goal would be for the patient to be seen by the physician within thirty minutes of arrival. Therefore, I created a second field showing the arrival plus thirty minutes. Field 2: GOAL...

I'm teaching myself how to use the user-level security wizard; however, I am running into a roadblock. I used a sample database to practice and saved it to a network drive. After running the user-level security wizard, my database was secured and a backup was saved as .bak. I shut down...

IT WORKED!!! THANK YOU!!!

FIELD 1 is a time format. FIELD 2 can be a text format with AM or PM.

Our clinics are separated in schedule by AM sessions and PM sessions. I would like to be able to report on either AM session, PM session, or both. When reporting, I would set the database to ask me "AM" or "PM".

FIELD 1: Scheduled appointment time. FIELD 2: Session (AM or PM) I would like "FIELD 2" to populate itself with "AM" or "PM" if "FIELD 1" is at or before 12:00 noon. Can anyone help me with this one? Scott Burk