Search results for query: *

It did not help, I had tried it before posting the question on the forum. remember this character came from main frame. I can copy and paste, but replacing will not replace it at all.

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?

I have to export when i click on File --> Export and choose the file as .csv, i dont see any step number 3 where i can choose field as text. I also saved it as a query and exported and i ended up loosing leading zeros. What does formatting query means. After saving query do i have to format it...

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.

Wow, It worked, Thanks a lot.

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 am trying to find the invalid users. First file is the combined list of valid and invalid users and second file is the list of valid users . SO if the first file has values in 2nd file that means he is a valid use and hence I put Y for match, if not found I put N for no match.

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

Thanks a lot and it works. Now I have something similar to that and I dont know whether Access can handle something like this or not. Here is my problem any help is highly appreciated. LEADOWNER AM Name AM Category AM OU (Blank) Ed Lucas Client Com - Benefacts...

Even when i take that "" it does not run, any suggestions?

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

Thanks PHV, it worked like a charm, u r real Guru, thanks once again

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

That is because I have to get the first AM Manager value from the beginning as soon as I find blank or null value in lead name column.So it will be Thomas King. In fact basically I will be finding the first value in AM manager column and then whenever i find blank or invaild in lead name column...

UPDATE Lead_with_suspect SET Lead_with_suspect.[Level III/IV AM Name] = DLookup ( [Lead_with_suspect]![ III/IV AM Name] , [Lead_with_suspect], Trim ( [Lead_with_suspect]![ III/IV AM Name] & '') and Not In ('Invalid','' ) ") where Trim( [Lead_with_suspect]![Level III/IV AM Name] & "") In...

Thanks for the code, based on my actual table name and field I coded it as follows DLookup ( [Lead_with_suspect]![ III/IV AM Name] , [Lead_with_suspect], Trim ( [Lead_with_suspect]![ III/IV AM Name] & '') and Not In ('Invalid','' ) ") where Trim( [Lead_with_suspect]![Level III/IV AM Name] & "")...

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