Search results for query: *

Unfort. no My problem seems to be this. I have records stored in numerous tables. For Record A. I have Data Objects 1 2 3 4 5 and 6 Data Objects 1 2 3 4 are in the table named ssInstructions Data Objects 5 6 are in the table name ssTextInformation Data Objects 1 2 3 4 are all within the...

I have 4 text fields that contain data from free format fields. With the table these fields are labeled as Text1, Text2, Text3, and Text4. Also in the same table there is a text type field named TextType. This field distinguishes the type of data contained within the text fields mentioned...

PH thanks for the response. Im a little unsure how to use the advance filter. I assume I can have this built into a Macro. Thing is my users need to run this excel daily and get the above result and they are worse off in excel as I appear to be. I have read another thread. thread707-934163...

Hello all, I have an excell spreadsheet that basically looks like this 118118 bank name -12345.00 12345.00 118119 bank name 12345.00 12345.00 118120 bank name 12345.00 -12345.00 118121 bank name 12345.00 12345.00 118122 bank name -12345.00 -12345.00 I need to create...

Hello all, I have an excell spreadsheet that basically looks like this 118118 bank name -12345.00 12345.00 118119 bank name 12345.00 12345.00 118120 bank name 12345.00 -12345.00 118121 bank name 12345.00 12345.00 118122 bank name -12345.00 -12345.00 I need to create...

Hey thanks for your help, it worked for me.

OK I have done what you said. However when checking the formula Subtotal := Subtotal + {FXLimits.Spot Limit} *.15 The system tells me that a number is required before the second Subtotal in the formula. Mike

Is there a way to add Subtotal figures together? Here is my issue I have a report that sorts Customers under their sales rep. Each customer has contracts underneath them. Each Customer has a Contract limit. Each Contract has a Profit number. For Risk management purposes we only show 15% of...

Yes I agree it should be a cross tab, but how do I pull in data from the 3 different areas, if there are no consistant linking fields. Every month the countries and banks can and will change. Thanks for your help. Mike

Hello, I have a small issue trying to bring data together from three different sources. I think sub-reports is the best answer to do this, but Im unsure of how exactly to pull it off. Here is what I need to do Example Sub Report #1 (product #1) Country #1 Bank # 1 Risk...

Hello, Thanks your help on this, both of you. I was able to figure this out I need to create two formulas #1 mid({field}, 46) #2 left({formula #1 field}, len{formula #1 field} & "") -25) Again thanks for you're help and I hope this thread helps others Mike

This didn't work. I recieved an error that it was looking for another ). Im able to pull the Reference number out using Mid(totext{field}), 19, 12) and Im able to pull out the account number using Right({field}, 10) Is there a way to have the formula pull everything between the 45...

Hello, I have a large text field that hold three major peices of information. Here is an example of what is in this field: Source Reference: 040303004902 Customer Name: Michael Technologies Inc Debit Account: 3305052327 Now I know how to pull out the reference number and the account number...

Hello, We have an excel spreadsheet with several worksheet tabs. I need a macro that we can save individual worksheets to .cvs format All of my attempts have failed. Im very new at using vb and macros. This is what I have Sub SPOT_CSV () Windows("AMRATES").Activate Worksheets...

I wonder if anyone else has this same issue. I have two users, who work with crystal reports regularly running pre-built reports. However whenever a True/False statement is used they receive an error. We have about 20 users working with crystal reports and only these two users have this...

Thanks your suggestion worked. I used Instr({table.field}, "*O") > 0 it pulled all the shortnames correctly. Appreciate your help Mike

Hello, I have a SQL7 Database of Customer info. Every customer is assigned a shortname. There are two types of customers. My users a long time ago made a decision to add a *O to all of one type of customer. Now they would like a full list of all these customers with the *O in their...

Hello, I have 8 or 11 digit codes that I need to pull the 5 and 6 character out of in order to complete a formula. say the code is AEIBUS33 I need to pull the US out so I can do an If/Then statement to transalate US=United States. say the code is HSBCHKHHHKH I need to pull the HK out to...

THANK YOU Have never used the Top N experrt before Mike

sorry little new to crystal How do I use top N to complete this?