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

Part and Inventory Search

Back
Top