Search results for query: *

I got a flat file from the main frame and when I opened it in any text editor or even in excel I see escape characters which looks like
. I can high light that and delete it. But my problem is that it is a huge file and that kind of characters are found at many places throught the file. How...

For a Reportsmith conversion, in the rcv file, is there a wild card for the old owner name or do we have to have each old owner name in the rcv file per table? The following is an example of a table change entry in the rcv file: [Tables]...

We have new reportsmith version 5.6. I can run reports and see the ouput but when I save the output in any format like txt or csv or xls, it saves the ouput. But I dont see any data when I open those files. Any one has any idea why it is doing so and what is the solution?

When I export table to csv file I loose all leading zeros which does not happen when i export it as xls file. What should be done to retain the leading zeros during export to a csv file.

I have a column where the values have decimal places like 320.0, 734.0, 850.0, 1200.0 etc which I want to make it as integer only like 320, 734, 850, 1200 etc. Can we replace the exsiting values by using some function, any help is highly appreciated.

I made a spreadsheet by combining two files and it looks like as shown below F.Name1 L.Name1 F.Name2 L.Name2 Match John Reed Nancy Lu Y Mike Dandy Kathy Rino N Levy Nick James Mitch N Lou Rice Long Lee...

Hi I have two tables one is called lead and another one is called contact. Companyid is the key in both tables. For each lead there can be either one lead or more than one lead. I would like to find out lead with more than one contacts. I did the grouping based on company ids and pulled the...

Hi I have two tables one is called lead and another one is called contact. Companyid is the key in both tables. For each lead there can be either one lead or more than one lead. I would like to find out lead with more than one contacts. I did the grouping based on company ids and pulled the...

I have a field called duns number which is a text field 9 charsacters long. I want to update this field if it is 8 field long by adding one zero in front of it and two zeroes in front of it. I wrote the statement, but it shows all kinds of errors, it says it cannot update due to conversion...

I have a spreadsheet and two of the columns are called Lead Name and AM Name Lead Name AM Manager 1. InValid Invalid 2. Invalid (Blank) 3. Rick Hu Thomas King 4. (Blank) John Reid I have to update the...

I have a spreadsheet and two of the columns are called Lead Name and AM Name Lead Name AM Manager 1. InValid Invalid 2. Invalid (Blank) 3. Rick Hu Thomas King 4. (Blank) John Reid I have to update the...

I have not used Dlookup function and I went thru the expression bulider to use it while updating a table using query. I have the following situation as an example. I have a table called Leads and it has two of the columns are called Lead Name and AM Name Lead Name AM Manager...

In access query when I put the value of “Referral - AC (H&W)” in the criteria field I am getting the following error. The expression you entered has an invalid .(dot) or! Operator or invalid parentheses You may have entered an invalid identifier or typed parentheses following null constant. I...

I have a table called Leads in access database with about 25 fields. One of the field is “Lead Owner” and the table has another field called “AM Manager”. If the value in field Lead Owner is either invalid or blank then the first AM Manager field is populated in the Lead Owner field, if the...

Hi I am working at a client's site where they have a sql database residing on SQLServer 7.0 for HR Services and they have peoplesoft database residing on SQLServer 2000. They are still using their old HR Services system for some applications. They want some of the data(like EMPLID...

I have a spreadsheet with 60 groups for a total of 2400 records. Is it possible to select randomly from each of these groups.

Is it possible to write vba code in excel to FTP the file to different environments such as NT server or UNIX server and if so can you please help me with the code. Thanks in advance

In one of the cell I have a drop down box showing various values which can be picked by end user. Is it possible to have another drop down box in adjacent cell which shows different values for each value picked up in the earlier cell.

I have a spread sheet which has about 999 rows. User keeps typing in the data in the columns. At any time if they want to take a print out of the spread sheet the logic is as follows. We have to find out the last row in which they have entered the value in the first column and then print from...

I have some data validation comments and these are visible whenever the mouse is moved over a cell. Is there a way to print these comments as I have to print only these comments for about 5 cells which has different comments.