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

    Transpose Columns into Rows?

    Hi All, Hoping someone might be able to help, I'm building a report and think I need to transpose the columns into rows or do some sort of crosstab, please see below for an example of the data I'm getting: ID 1 2 3 4 5 6 85435 0 7.5 0 7.5 0...
  2. cursedkorok

    Group consecutive dates

    I've moved to ' to ' concat to be before the end date range rather than at the end of the start date so it fixes the to being printed on a single date: Not sure how to add "day(s)" at the end of that, if its the first record and the last record then print "DATE x day(s)
  3. cursedkorok

    Group consecutive dates

    Hi Pete, I've only had a chance to test the formulas today, I'm really sorry for not getting back to you earlier and I genuinely appreciate you going through the effort and trying to help. Please see below for results I got so far, this report runs through the whole employee database, I think...
  4. cursedkorok

    Group consecutive dates

    Sorry I'm not sure how a work day calendar helps in this case, I'm trying to achieve something similar to this, the report pulls absence details from a database I just need it to display as from - to if consecutive days and then count the number of instances.
  5. cursedkorok

    Group consecutive dates

    Sorry the 23/12 is supposed to show as 19/12/2023 - 23/12/2023, but no the count should be 4, my mistake.
  6. cursedkorok

    Group consecutive dates

    Hi everyone, I'm trying to create a report which looks at dated records and displays them as ranges then counts the individual ranges and the number of records. Report is grouped by ID. Selection is based on date ranges and record type. Data example: ID: Dated: 21 01/12/2023 No record...

Part and Inventory Search

Back
Top