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 gmmastros 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. 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...
  16. TomSalvato

    Exporting more than n 256 columns to XLS

    Hi experts, I'm trying to export a crystal report (using CR2013) using the 'Microsoft Excel (97-2003)' option. Unfortunately, I have a column for every day of the year, and a couple more. The export stops on column 256 (IV). This is because crystal automatically exports to an XLS file, instead...
  17. TomSalvato

    First Dynamic Cascading Parameter only returning 10 records

    Forget it ... forgot about the 1000 record limit. Need a command after all. Thanx anyway! -TS
  18. TomSalvato

    First Dynamic Cascading Parameter only returning 10 records

    Hello Experts - Haven't used a simple dynamic cascading parameter in a long time. No commands or anything complicated here. Just one table, two fields. Field A (we'll use State for example) drop box should display 50 states then Field B (City) drop box should display all cities for the...
  19. TomSalvato

    Dynamic Cascading Parameters ... from a command

    I think I've got it. I knocked the select in my command to just those two fields that I want in the parameters, plus a municipality code ... THEN, I linked the command back to the initial SERVICE_VW via the district and municpality code from the command ... now, I have the parameters working...
  20. TomSalvato

    Dynamic Cascading Parameters ... from a command

    That's interesting. There's no way the district/muniname combo will ever be more than 1000. Here's what my command sql looks like ... SELECT distinct("MCD_BOUNDARY_V"."MUNINAME"),"SERVICE_VW"."DISTRICTNAME", "SERVICE_VW"."MCD", "MCD_BOUNDARY_V"."MUNNUMBER", "SERVICE_VW"."OBJECTID" FROM...

Part and Inventory Search

Back
Top