Search results for query: *

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

I need two activity code dates (BK Date and DT Date) for an application on a report. I am using the BK activity code in the selection criteria since I only want booked loans. On the report they also want to see the DT date, which I assume occures after the BK code. I have the BK date on the...

How do you code a formula to pull only applications where the activity code DP has been used but not DI? (application table) app# = app.opr_app_nr (activity table ) activity code = act.act_cd

Thanks for the help, I got it work using the cross-tab. Chip

Employee 4/11/03 4/12/03 4/13/03 4/14/03 John Doe 56 64 38 45 here is what I am working with for the formula so far, I think my problem is finding a way to count the totals: If {DLY_ACTIVITY.ACTIVITY_CD} in ["LS", "RC", "RW&quot...

I need a report that shows each employee's total work for the day, broken into the last four days. So each employee # would have 4 totals columns in each row just showing the number of applications they touched. How do you set up the formulas for something like this? Work is decided by many...