« First « Previous Comments 13 - 52 of 74 Next » Last » Search these comments
@richwicks
Thanks! I am real curious in seeing how that is done, especially the logic.
Thanks again, richwicks.
I uploaded the excel file with the dates ranges for Nov (includes leases that start in Oct and those that start in Nov and end in Dec). And believe me, I would not upload anything illegal or in poor taste. If the lease date starts in Oct, and ends in Nov, I would only want the actual days in Nov for the November report.
To HeadSet
OK, got it that time. I see it's in xlsx - I may be able to read it directly rather doing conversion on it. Earliest ETA is Monday of next week.
richwicks saysTo HeadSet
OK, got it that time. I see it's in xlsx - I may be able to read it directly rather doing conversion on it. Earliest ETA is Monday of next week.
Thanks again, I really appreciate this.
I am familiar with VBA used in Access, so in the meantime I will install perl and check out a few tutorials.
Can you post the input file in CSV format. At least some chunk like100 lines of it is too large, for reasonable testing.
BTW @HeadSet - ever heard of LibreOffice?
I love LibreOffice, and before that OpenOffice. Any "missing" feature needed could be added with plug-ins. I had LibreOffice on all worker stations for years. However, I had to install MS Office because puds would send us Excel files with a formatting that LibreOffice could not read. These were usually files from government agencies, where the formatting was just for looks (like cool titles) and nothing of substance. Also, workers wanted to have "MS Office experience" on resumes so they complained until the owner made me buy Office. By the way, unlike Excel, LibreOffice Calc does not have a file size limit. I was able to extract data from an old legacy dBase3 file into Calc to parse it down. Excel would only be able to pull the first third or so before maxing out, and truncate the rest.
Also, if one want to write a user manual or any other complex document with pics and charts, LibreOffice Write is far superior to Word. With LibreOffice, you can adjust a graphic without scrambling the adjacent text formatting. With Word, moving a graphic even slightly can jumble up the text formatting for several pages.
Also, workers wanted to have "MS Office experience" on resumes so they complained until the owner made me buy Office.
OK, I may be doing the dbo source (FROM) wrong:HeadSet says
Oops, I see that I named the column "VehicleNumber: and not "Cab"
Then gives you data that looks like this..
That is what I need! I just got to take out the errors I made copying your design.
OK, I may be doing the dbo source (FROM) wrong:
Just hope I do not remind you of your co-workers.
As lately I'm so disgusted because everyone and everything is in the way of me getting my job done. When a problem comes up, that I would solve and turn around in minutes, hours or days. By time everyone has stepped on it and poked their finger in the pie, it's three months later, and I can't bring my self to even do it.
Change jobs.
I burn out, I'm fucking crispy fried now. Everything is a roadblock. New job, fun new interesting, old job, boring stale and I'm just doing maintenance.
I was literally getting up every day wanting to die rather than go to work sitting in front of a computer running data through a script. It was a nightmare.
Next time I'm off, I'm taking 6 months off to do all the crap I've been wanting to do, but have been blocked at my job from doing. I can't work on two entirely different projects at the same time - I need time to concentrate on what I want to work on. When I'm sick of that, not only will I have a cool product, I'll be sick of working on my cool product.
Thanks for giving me something to do, I actually felt like doing.
Your welcome! Now I will look over your code in detail and transpose it to Access. I really appreciate this, it will save a ton of work.
but I don't want to be in technology or programming. I'm tired of the pointlessness of it. No matter what you make and what you make it for. It will be obsolete in a few years. Libraries deprecated and OS they were written for end of life cycle.
« First « Previous Comments 13 - 52 of 74 Next » Last » Search these comments
I cannot figure this out in Access tools/VBA or Excel tools/VBA. I really just need to know how many days each cab was leased out for the month, and I think this grid is the way to do it. For example, a cab that was leased out from 1-8 Nov and then from 8-15 Nov was leased for 15 days. Output is any way to show Cab 1 for 24 days, Cab 3 for 30 days, Cab 6 at 4 days, and so on. I do not want to double count dates that overlap.
Any ideas, to at least point me at what logic to use? Does not have to be Access or Excel.