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

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

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

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

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

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

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

I need a report that would show where a REACTIVE workorder (RD) have been generated 15 days or less after a PREVENTIVE MAINTENANCE workorder (PM). These are all in one table called WORKORDER, but the WORKTYPE would be either PM or RD. I would also like to group them by ASSETNUM and Sort by...

How can I add more columns to a subtotal function for info only. I subtotal the total hours in coulmn "L" at each change in PM#'s in column "B" Then I copy the subtotal and paste it to another spreadsheet. The subtotal info is only the PM# and the TOTAL HOURS. I would like to capture the PM...

I have a webpage with links to an excel workbook where users open it, go to Sheet2 and filters on "A1" for their name to get their data. I saw some samples of JScript doing everything but filtering, anyone have any code? Can this be automated to autofilter on opening from hyperlink. I could...

I have a webpage with links to an excel workbook where users open it, go to Sheet2 and filters on "A1" for their name to get their data. I saw some samples of JScript doing everything but filtering, anyone have any code? Can this be automated to autofilter on opening from hyperlink. I could...

I have an oracle database that holds maintenance records. I'm looking to find where my "REACTIVE" calls have increased this year over last year per "ASSET". Field names: WONUM= work order number. WORKTYPE= work order maintenance types (REACTIVE). ASSETNUM= unique asset id tag. REPORTDATE=...

I have 4 columns of text-dates that I need to convert to excel dates, mainframe type xml exports. I know using the Text to Columns works for me but I can only do 1 column at a time. I also recorded it as a macro. Question: can I do all 4 columns (R:U) using this macro? Columns("S:S").Select...

I have a spreadsheet with the following data-> Wo# Description Need Date Start Date 1002 fix lights 1-10-2008 1-8-08 1003 change filters 2-5-2008 2-4-08 1004 move totes 2-6-08 1005 relamp...

I'm looking to improve the following macro-> Managers are using this to hide everyone that they don't have responsibility for. Unfortunely there isn't a common criteria between his people, so they run this to hide the rows that doesn't have their people on them. J column contains their names...

I'm trying to identify the best way to display the budget month in the details or if it is possible. When I run my report for August, I use the date range 7/27-8/30. Our work weeks are Friday -Thurs. (Last thursday of the month is the end of the Budget Month and the new one begins on Friday)...

I have a maintenance software that exports data into excel as .csv. When the estimated hour and actual hours export they look like the following example. * The first column is the data just as it appears in excel. * The second column is the format (right clicking on the cell and noting the...

I have a description field that I want to show about 3 inches of data only. However, I would like to not cut off the description unless I add ... to indicate to the users that there are more information in the field that is not visible on the report. I started using this formula to do exactly...