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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by barrattp

  1. barrattp

    Group and sum records based on Nth Largest Summary fields

    Hello, I am trying to group records based on a set of “Nth Largest (N=1)” Summary fields. I have to report on an equipment table (of which I have no control of reconstructing) where there are multiple records for the same piece of equipment. For a pipe asset the equipment attributes are listed...
  2. barrattp

    Show the nuber of work days excluding week ends

    Hello, I an trying to create a formula that will give me the number of work days between two dates excluding the week end. I have been using the attached formula that I got out of Crystal Decision. It calculates the number of days BUT does not exclude the weekends. Eg if the start date is Fiday...
  3. barrattp

    Does date fall on a work day or on weekend

    Hello. 1.I have to identify if a date falls within a work week (Monday to Friday) or falls on a week end. 2. I also will need to set up a proceedure to identify Public Holidays. The database that I am using does not have a calender table. I was going to hard code an If statement with the...
  4. barrattp

    Establish if a time record falls within a Core Period.

    I am trying to create an IF Statement that will establish if a Date/Time field falls within the core period of between 7:30am and 4:09pm. I am after a "Y" or "N" result.
See more

Part and Inventory Search

Back
Top