Search results for query: *

Is there a way to paste the actual text of a cell (e.g. IF statement, calculation of some fields) not the formulas or values without adding the $? Example A1 =Sheet1!C128 A2 =Sheet1!C129 When I copy row 1 and 2 into row 10 and 11 it will get a mapping of A10 =Sheet1!C138 A11 =Sheet1!C139 I...

I’m using Excel 2002 Is it possible to replace a special character (or a combination of mutable) with a hard return? (Alt Enter) Thanks

I would like to add a conditional formatting (in excel 2002) for the entire line. The color of all columns should be changed based on the information in column G. Is this possible without code? Thanks

I’m copying a table from a word documents into excel. However, every hard rerun (Enter) creates a new row in excel. Is there any way to remove all hard returns from a word document? Thanks

MsWord has a build in option to compare and merge documents. I’m trying to compare an excel documents. Is this possible? Does excel also have some kind of tolls for this? Thanks

Activating Format Painter with a shortcut I’m using a lot the Format Painter button. Is there a way to set up a shortcut like Ctrl plus any button to activate the Format Painter (the same as Ctrl B to Bold fields, ctrl X to Cut etc), so I only need to click on the filed I want to have the same...

I’m currently using a function (that is executed with a click of a button) that selects a report and converts it to a .snp format. Then, it creates a new email and attaches the snapshot file without saving the file in a temp table. However, not all my customers has snapshot viewer installed. So...

I have a document with about 40 sheets. Is there a way to have the Page x of x be displayed on all sheet based on sheet and page? Each sheet has 2 pages. Like Sheet 1, Page 1 to display Page 1 of 80 Sheet 1, Page 2 to display Page 2 of 80 Sheet 2, Page 1 to display Page 3 of 80 Sheet 2, Page 2...

Whenever I set the document to PageSetup.FitToPagesWide = 1 PageSetup.FitToPagesTall = 2 It fills up the entire page. However, once I use the “Page Break preview” it automatically reduces the size of all rows/columns on page one, even there is still enough space on both sides of the page. I...

I would like to filter records where the first 3 characters start with xyz. What is the function for this? Thanks

I have created a few formula fields that I added to my group footer. Now I created another formula field that is based on the fields from the formula field that I added to my group footer. Is there a way to group the report based on the last created formula field? Thank you Joe

I used this formula to identify the different If ({@Diff}) >4.99 and ({@Diff}) < 10 then "5-10" else If ({@Diff}) >9.99 and ({@Diff}) < 20 then "10-15" else "N/A" However, so me differences are a negative. I would like to changes the formula like this, if the diff is more display “A1” if it is...

I’m used to use the NZ( ) function in Access. What should I use in crystal? Thanks

Where can I get a full description of the different between all Join types? For Join type, Enforce Join, and Link Type Thank you Joe

Each product ID can have multiple lines for different versions. The Product ID is not the primary Key. I’m grouping the report by Product ID I would like to create a formula that returns the price field for the product ID where the version is the highest. What would be the code? Thanks Joe

In have a filed Cost, Aged, and Item Each Item cam be in multiple aged fields I would like to create a report that summaries total cost by aged range. It should be incremented by180 Like 180-359, 360-539, 540-719 How can this be done? Do I have to create a sum field for each Aged Like 180...

My report is linked to a Unix database. The order date is coming up as a string type, it includes the seconds, and I can not filter by date. How can I convert the field to a date type? Thanks

Currently I do not have access to create views. I can only create reports. My first table has a status field for discontinued items. (It is a text field) My second table also has all items with more details, but it does not have the status field. I would like to display the information from...

This is very simple but I do not know it. What is wrong with the if statement below? if ({tableOne.fieldOne}) = "Y" then "Y" else "n" Thanks

I'm trying to ling access to a table in Informix/Unix and I got this error "The operation failed. There are too many indexes on table xyz_Informix Delete some of the indexes on the table and try the operation again" This is the only table I'm bringing in to access. I do not want to use any of...