Search results for query: *

I starting a data pull using access and I am looking for ideas before I get too involved. I'm looking to know if there is a way to find RD workorder's (reportdate) within 15 days after a PM workorder's ( actfinish) date on an asset using access and Oracle. Fields- VIEW_WORKORDER.WONUM...

MajP, Did you run this in Excel? or access? Where do I add the code? I need some steps as to where to add the code and how to run it. thanks for your time tav

Andrzejek- So the folling data is in an oracle database. PMNUM FREQUENCY FREQUNIT NEXTDATE1 PM1 1 MONTHS 10/12/2015 PM2 2 WEEKS 10/12/2015 PM3 30 DAYS 10/12/2015 PM4 1 YEARS 10/12/2015 Every week a script runs to see if anything falls within this week and if it does it produces a...

I have a table with a frequency (the value at which something will happen), frequnit (units at which it will happen), nextdate1 (next time we expect it to happen). FREQUENCY FREQUNIT NEXTDATE1 nextdate2 2 MONTHS 1/2/2015 3 WEEKS 10/5/2015 30 DAYS 2/1/2015 1 YEARS...

Ok, actually they both work great. Thanks. tav

PHV, Not sure where to add this, but I added it to the textbox Control Source and it returns #Name? thanks tav

I have a database that the tables are populated by odbc (external oracle database), via a push button running a refresh macro and a creating a few make tables, charts and reports. I have a form called "Main_Form" on that form I have a few textboxes that I'm using as a stoplight chart. One of...

Does anyone have a calendar style report that is functional like the one LBASS created. I was hoping to find one that doesn't use other excel files for the tables and is a stand alone report. I have one table called PM and the field name is called nextdate. I have a frequency called freq (ie..1...

I have Crystal Reports 10 (CR Developer; FULL ver 10.0.5.1177) I'm using to hit the a field in an oracle database {LONGDESCRIPTION.LDTEXT}. I'm currently using a formula to convert rtf to html and I'm also using the format "text interpretation set to html". Formula works great- stringvar...

dhookom, thanks for the quick response, The vb works great and was easy to use. thanks, tav

I have never used vba in access and I can if I need to, but was trying to keep it simple with just a few formulas. I was using Excel and now have switched to Access. Here are the 3 formulas that I used in Excel. TRIM(MID(SUBSTITUTE("," & $I8&REPT(",",6),",",REPT(" ",255)),1*255,255))...

Forgot to mention, i want to parse the description into 3 different columns.

I'm looking for a formula that will parse a comma delimited field. I think I have the first formula-> Class: IIf(InStr(1,[ASSET.DESCRIPTION],",")=0,[ASSET.DESCRIPTION],Left([ASSET.DESCRIPTION],InStr(1,[ASSET.DESCRIPTION],",")-1)) I am struggling with the other 2 formulas. My data with 3 example...

Thanks Brian, I used the suggested formulas as - First formula- split({ASSET.DESCRIPTION},",")[1] Second formula- if ubound(split({Asset.Description},",")) >= 2 then split({Asset.Description},",")[2] else "" Third Formula- if ubound(split({Asset.Description},",")) >= 3 then...

The description for the first asset is SHREDDER, PAPER This should come out as SHREDDER using the first formula (which it does) This should come out as PAPER (has an error) The first formula worked as suggested split({ASSET.DESCRIPTION},",")[1]) The second formula saved, but it has an error...

I need a formula for crystal that would parse out the first word, then another for the second word and another for the third word. The description will always be delimmited by commas. My goal is to parse them into 3 different columns. I can now do this in excel, but I want to do it crystal...

Ok i think I found a pretty good solution that I have never seen before. AIR CONDITIONING UNIT, SPLIT, COMPUTER ROOM UNIT AIR CONDITIONING UNIT =TRIM(MID(SUBSTITUTE("," & $N1&REPT(",",6),",",REPT(" ",255)),1*255,255)) SPLIT =TRIM(MID(SUBSTITUTE("," & $N1&REPT(",",6),",",REPT("...

I have a workbook with over 50,000 rows of data. My "N" column has some data delimited by commas. I need to parse the first 3 sections of the text in the "N" column into 3 separate columns (K, L, M). Can't have trailing spaces or commas. I can't use "text to column" due to this is a shared...

This is a download from our front end maintenance software. Everytime the data changes we hit a link that exports the data to excel. We sort it and then we save it as an excel file. We have 20 different sites with 5 or so people at each site downloading the freshes data all the time. I usually...

Is there a way to convert this text to a date. It gets imported into excel as text and is not able to use the format function in excel. I can't seem to find a formula to use. Here is the date currently- Wed Sep 21 00:00:00 PDT 2011 I would like it to be- 9/21/2011 Thanks, tav