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!

  • Congratulations Chris Miller 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. bpenney

    1st of month formula help

    Thanks Blue, Worked like a charm. cLFlaVA, thanks for the input also.
  2. bpenney

    1st of month formula help

    Hopefully someone can help me out. What I want to do is return a date in cell B1 based on the date input in cell A1. What I would like the formula to do is to add 90 days to the date in cell A1 and then return, as an answer, the first of the next month. What I want to use this for is benefit...
  3. bpenney

    Help with grouping on report.

    The fields are linked by the employee ID. All of the fields in the report are actual database fields, except for the date field which is the only formula in the report and it is used to convert the Julian date, as seen below. {timedata.date}+date(1800,12,28) I had tried some grouping but it...
  4. bpenney

    Help with grouping on report.

    Hi all, I'm having a little difficulty in getting the information in my report the way I want. I'm using CR 8.5 on a MS Jet database. I have two tables I'm using Employee and Timedata. The employee table contains the employees name and the timedata contains the hours charged to each code, the...
  5. bpenney

    Help creating report

    LB, Used your suggestions and it worked like a charm. Thanks a million!! BP
  6. bpenney

    Help creating report

    You're right I was just theorizing, but let me see if I can figure this out now. I am going to have three fields in my report ({Eperson.name}) ({Ejob.title}) ({Etrain.classdescrip}) All of the training history for the employees is located in the ({Etrain.table}). Now what I am thinking is...
  7. bpenney

    Help creating report

    Hi everyone, I am trying to create a report and I just can't seem to come up with a solution, hopefully someone can give me an answer, point me in the right direction or let me know if this is even possible. What I am trying to do is create a required training report that returns a list of...
  8. bpenney

    Round up to nearest 1000

    This is great guys, thanks a lot! Brian
  9. bpenney

    Round up to nearest 1000

    I need a little help on a formula I'm trying to create. I am using Crystal 8.5 on a MS Jet database within the Ceridian Source 500 product. I am using a calculated field that gives me 150% of annual earnings for life insurance. I want the calculated field to round up to the nearest 1000. For...

Part and Inventory Search

Back
Top