Search results

I have a report that comes from a query with multiple expressions. The expressions look something like this: IIF([TimeArrive]>[TimeTriage],DateDiff("n",[TimeArrive],[TimeTriage])+1440,DateDiff([TimeArrive],[TimeTriage])) This works great and my report gives me my columns for each expression...

Thank you for the help. I knew I was missing something simple.

In my database, I am tracking Lactate values. The data is reported from the lab as #.## I set up with table and form orginially as a general number with 2 decimal places. I noticed that the field in the Table and Form was being rounded to the nearest whole number. I then changes the from...

Thanks recyan. I was missing the quotation marks around the option value. It's working now wonderfully.

Hi, I am making a report off of a query. The report is returning values from a Option Group. 1=Yes, 2=No and 3=N/A. The report returns the numeric values and I want the value labels instead. So, I created a column in the query for exp1 which looks like the following...

Unfortunately, he bit of code that I was given did not work, so I did not save it. I will have to ask my friend again what the code was that he gave me. Data is copied from the old record to save input time. It is easier to change the old data instead of entering everything each shift.

Very new to VBA programming (complete noob), but I do know that other autofill threads did not have the information I was looking for, or it may be what I am looking for is elementary enough that I should know, but again...noob. So, this is what is I am after... I have a db that collects some...

Hi. My name is Chris. I work in a hospital in Maryland. I recently started making databases for my department using 2003. A co-worker and I enjoyed it so much we are both working on 2007 (upgrade the hospital recently got) and 2010 (upgrades we both got on home machines).