Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. EricRN

    Need to Calc Time Broken Down in Shifts

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

    Need to Calc Time Broken Down in Shifts

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

    Field not printing on 1st record when removing dups.

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

    Field not printing on 1st record when removing dups.

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

    Not all group axis names printing on chart

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

    Calculating Elapsed Time Spanning Midnight

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

    Calculating Elapsed Time Spanning Midnight

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

    Calculating Elapsed Time Spanning Midnight

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

    Calculating Elapsed Time Spanning Midnight

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

    Changing autosave setting in Excel

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

    Email form info from users to helpdesk

    Got it! I appreciate everyone's help Eric
  12. EricRN

    Email form info from users to helpdesk

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

    Email form info from users to helpdesk

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

Part and Inventory Search

Back
Top