Search results

this worked... thanks!

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

PERFECT! That works! Thank you very much! :D

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.

I figured out a workaround based on your answer. I wasn't able to use = [startdate] and [end date], I had to make two separate text boxes for each... =[startdate] =[end date]

In my query, the criteria states: Between [Enter start date] And [Enter end date] In my report, under the report header, I created a "text box", left the lable as is and typed the following into the Data Control Source: =[Enter start date] And [Enter end date] Now, I end up with a -1 in that...

Yes, but if I do that in my report, it does the following when opening the report: It prompts the user to enter the date range. (to pull the correct data) It prompts the user to enter the date range again. (for the report title) Is it possible to enter it only once and have it pull the right...

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

I got the last problem fixed... Thanks for all of your help!

Adding records to your sample DB file On this database, I would not be able to add records. What must I do to add additional records?

I apologize... I have no idea what you are suggesting. I created a new table with MON AM in the first field and S1 in the second field. Similar data in fields 1 and 2 for the rest of the week. Then what? I really apologize.

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 asked a question about the same database but a different formula. Yes. That suggestion worked and is on the footer. This question ask about calculating certain items based on certain elements pulled from the date. Once pulled, it refers back to the providers table and grabs the appropriate...

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