Recent content by srburk

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?