Recent content by ChipF

I have a formula that concats the last name and first name, now I want to select records where the last name matches and the first few letters of the first name match how would I do that in the selection formula? concat = LastName+", "+FirstName {@concat} like "BAUMGARTNER, SUS*

I want the report to show all APd apps with G2, G3 and all APd apps with a G4 over 250K

Hello, I can't get this to work, I want it show apps like G2, G3 and/or apps like G4 with a loan amt over 250K {DLY_APPLICATION.OPR_LOCATION_NR} in ["010623", "010633"] and {HE_ACTIVITY_FACT.ACTIVITY_DT} = currentdate-1 and {HE_ACTIVITY_FACT.ACTIVITY_CD} = "AP" and...

How do you create a formula getting the turntime in hours (not days) from the application system entry date (SE) to the first call (CI) using IBM DB2 database?

Why won't dates in Excel sort in order like they do in Access, and also why does a Yes/No field change to True/False in Excel? Any way around these in either program?

What is the formula syntax to show the time between an SO and SA activity code? So I want something like this: If {DLY_ACTIVITY.ACTIVITY_CD}= "SA" then SA{DLY_ACTIVITY.ACTIVITY_DT} - SO{DLY_ACTIVITY.ACTIVITY_DT} else 0

Ok, I found it, thanks for your help Kevin.

I just don't know how to change the datasource, is there a button for that? I have Access 97. Thanks Chip

Ok, my question is how do you link the report to the new query? I have another query with no parameter but I still have the list box from the old query, how do you change that? Chip

I created a report that runs from a query with a parameter in it. I no longer want that parameter to run on this report. The query is linked to 3 other reports so I don't want to change the query. Is there a properties tab or something in reports that can eliminate parameters? Chip

Is there a way to add a digit (number or letter) automatically to an autonumber as a primary key?

I want the selection formula to select the customer comment field only if it starts with a number. This is a way to identify certain codes throughout the day. Most comments are letters, but I only want numerals. How do I do this? Is there something I can put after (starts with)?

How would I get a count from this data for the number of QCs before DPs? This is the output I have. DP date QC date App ID 5/21 12345 5/21 12345 5/24 12346 5/25 12346

What is the limit for Crystal 7.5 report rows of data? Is it around 400K or 500K?

when I try to refresh my report this error appears ODBC error [MERANT] [ODBC DB2 Driver]SQL0805N Package TEST.QEURV1 was not found SQL STATE=51002