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 TomSalvato

  1. TomSalvato

    Getting the Monday date from a week number

    Perfect. Thanks so much, strongm! Slight modification to the DateSerial function for my needs. Here's the final formula for anyone else that may someday be looking at this ... MondayDate: DateAdd("ww",[My_Table]![Week Number]-1,DateSerial(Year([date]),1,1)) * Putting the Year function...
  2. TomSalvato

    Getting the Monday date from a week number

    Good morning, Experts. Hopefully there's an easy way to do this. I'm trying to create an expression in builder. I have a 'Week Number' field (which is just what it sounds like, the week number of the year for that record). I'd like to get the Monday date for that week number. For example: if...
  3. TomSalvato

    EXCEL-formula help

    Combo - never even heard of that formula. Does exactly what I needed. Thanks again, sir.
  4. TomSalvato

    EXCEL-formula help

    Perfect! thanx, Skip!
  5. TomSalvato

    EXCEL-formula help

    Good afternoon, Experts. I'm need a formula to calculate COL-C. If both A and B have data, then I need the result (in COL-C) to show both fields separated by a / character. If only one of A or B have data, then I need the result (in COL-C) to show just the one field (no / character). I'm very...
  6. TomSalvato

    AVERAGEIF question for Excel Experts

    Perfect! Exactly what I was looking for. Thanks, Andrzejek!
  7. TomSalvato

    AVERAGEIF question for Excel Experts

    Hello all, I think what I'm trying to do is pretty straight forward, but I'm no excel expert (sadly). I have three columns, I want the average of the contents, depending on how many columns are greater than zero. So, if two of the three cells are greater than 0, I want to divide by 2. If only...
  8. TomSalvato

    Help with a DOS command that isn't working for me

    You're right, that is precisely how the 'date' function returns the date. I'll need to replace the \ with - symbols. I will fool around a bit using your previous posts. Thanks again. -TS
  9. TomSalvato

    Help with a DOS command that isn't working for me

    Thanks for the replies, guys. Forgive me, but I really am a novice with DOS commands at this point. So the line I got from another site ... copy TEST.txt TEST-%DATE%.txt is not even close? Keeping in mind, i just need a datestamp on the target file name, the format doesn't really matter. -TS
  10. TomSalvato

    Help with a DOS command that isn't working for me

    Hello experts - I'm hoping this is a simple request, I haven't had to use too much DOS in recent years so I'm probably forgetting something common. I need to do a basic file copy from one location to another, but I need to target file to get a date extension so that it doesn't overwrite files...
  11. TomSalvato

    Exporting more than n 256 columns to XLS

    Hey lbass. Long time no see. Hope you are well. No the date ranges refer to a specific time allowed to do certain work activities in areas where there are endangered species present. They start/end at all sorts of points of any given month.
  12. TomSalvato

    Exporting more than n 256 columns to XLS

    It really doesn't have to be in excel if I could get the gantt chart to do what I need. I would wind up exporting it to PDF format. I'm not sure CR can't do what I need, I just can't seem to find any useful documentation or examples of how to create what I'm looking for. I have no experience...
  13. TomSalvato

    Exporting more than n 256 columns to XLS

    Yes, those two fields are not shown on the pic, the START_DATE for that row is 08/01/2020 12:00:00AM, the END_DATE is 02/28/2020 12:00:00AM. Note how it 'wraps' around the year ... so really, that end date would be 2/28/21 ... but we only care about the day and month. The people loading the data...
  14. TomSalvato

    Exporting more than n 256 columns to XLS

    Ideally, I'd like a Gantt chart to look like the attached. Two records shown. All 12 months across the top. Then one line per record going down (no grouping needed here). With the chart next to each line. The data consists of the SPECIES_NAME (string), DATE_RANGE (string), START_DATE...
  15. TomSalvato

    Exporting more than n 256 columns to XLS

    Thanks, Skip. I'm really just trying to save the formatting that I'm doing in the report. I lose a little of it when I export using the 'workbook data only' option. Exporting to a CSV or text file would pose the same problem. I think I'm just going to have to deal with it. Curious as to why...
See more

Part and Inventory Search

Back
Top