Search results

My table, TblTYPE, will contain two field. TYPE DURATION There will only be 7 records in this table: FUS, 30 minutes POS, 30 minutes PRE, 30 minutes NOV, 90 minutes FUL, 90 minutes ANN, 90 minutes NPB, 60 minutes 1st question: How do I enter only minutes in the table for field 2? ------ I...

I have a table with forty different records. Each record has the name of a task and an assumed duration of time that will pass for each task. Currently, my duration of time is listed in each record in the a text format and is displayed like the following examples. :10 :15 :20 :30 :45 :90 :120...

I am attempting to determine the total amount of time that a physician (ATT) spends in a patient exam room. The physician goes in an out of the room multiple times. I use a datediff command to count the number of minutes between the IN and OUT. For each datediff, I use the Nz function to give...

Lets say I have 10 fields in a record. Each are unique in that they are all numbers (or time fields). Is it possible to run a query to determine the highest value amongst the ten fields in the record. For example, if one record contains the following values in 10 different fields: 12 65 72 25...

I am tracking the time (in minutes) that an employee spends on the telephone. The employee tracks the following numbers: CB1 - Call 1 begins: 12:01 pm CE1 - Call 1 ends: 12:05 pm CB2 - Call 2 begins: 12:08 pm CE2 - Call 2 ends: 12:32 pm CB3 - Call 3 begins: 12:32 pm CE3 - Call 3...

Besides the 25 listed on the Microsoft website, is there a website with numerous Access templates that one can download? I am looking at creating a database of employees and their required training classes. The db would track who hasn't successfully completed which course and who has.

The report pulls from a query. Within the query is a date field with criteria: Between [Start Date] and [End Date] This pulls the correct information with no problem. Is there a way to have the date range that was entered be displayed on the report header section without prompting the user to...

How would I combine the following into one field in a query? IIf([KEY]="SA",[T - Pro]![SA]) IIf([KEY]="SB",[T - Pro]![SB]) IIf([KEY]="SC",[T - Pro]![SC]) IIf([KEY]="SD",[T - Pro]![SD]) IIf([KEY]="SE",[T - Pro]![SE]) In other words, if KEY says SA then it will result with the data in SA. If KEY...

In a query I have a field that says: Mon AM Mon PM Tue AM Tue PM etc.... I would like a new field to look at the cell mentioned above and code it. If Mon AM then the new field would say S1 If Mon PM then the new field would say S2 If Tue AM then the new field would say S3 If Tue PM then the...

How do I pull out AM or PM from a given time? For example... 1:13 pm In column 2, I'd like it to automatically put PM. I was thinking... Session: Format([Time],"___") but I'm not sure what to put as ___.

I am working with a table containing data for each: Date of appointment Time of appointment Clinic name Doctor name Appointment Status (such as arrived, canceled, noshow) Appointment Type (such as return, urgent care, emergency) Duration (based on appointment type - could be 20 minutes, 30, 40...

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...

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...

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...

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