Search results for query: *

I tried to do the datediff function but the data was funky. I ended up trying the ctime function. Here's the formula I was working on: timeVar cstart :=ctime({casemain.actcase_start_datetime}) ; timevar cstop :=ctime({casemain.actcase_stop_datetime}) ; if cstart > ctime (23,00,00) and cstart <...

Hi, I am working on a report that will break down the time of a surgery into shifts. I need a way to calculate the amount of time spent in each shift for a start datetime and end datetime. For example, if I have a surgery that starts at 0730 and ends at 1330 then the elapsed time for day shift...

Thanks, you Guys. Unfortunately, the way the canned report is put together, made for some interesting resorting and grouping when I tried to add the patient name group. However LB's suggestion seemed to do the trick. I appreciate your responses! Eric

I am fixing an existing report, using Crystal 8.5, that prints out a surgery schedule. There are times that a patient has multiple procedures. In these cases, we don't want the patient's name, surgery time, and DOB to repeated for each procedure. For each of these, the suppress if duplicated...

I am using CR 8.5 and am trying to print a bar chart that lists surgeons in the group axis. The chart only lists every other surgeon on the axis. Now, I've already used the analyzer to decrease the font size and rotate the titles to 90 degrees. There appears to be room to insert the rest of the...

Thanks Mark, That looks like it may work better for me since my date fields and time fields are seperate. Eric

Thanks Howard! Since I have seperate fields for date and time (exported from a Btrieve program...don't ask, it's too painful!), I guess I'll have to combine those fields for both the surgery start and surgery end, then plug them into your formula. Eric

Unfortunately, it's a straight time field. I had tried the DateDiff function and ended up with the same numbers.

I am writing a report which will calculate the elapsed time of surgical cases. The problem is, some of the cases span accross midnight. This causes my field to be show up as almost 24 hours in minutes (ex. -1340). Here is how I have it set up: I have In Time and Out Time fields that are...

Kevin, If you're using Excel 97, Microsoft makes this statement: &quot;You can modify AutoSave settings, including how often to save, which workbooks to save, and whether to be prompted before saving. To do this, on the Tools menu, click AutoSave, and select the options you want in the...

Got it! I appreciate everyone's help Eric

Thanks! If anyone knows the VB for something like this, I'd would appreciate learning it from you.

I am putting together an Access application that I would use for a help desk. I want the users to be able to be able to enter information on a form and then use a button that would send the form to the helpdesk email address. How do I go about having Access email the form? We are using Novell...