Search results

I have an expression that converts a string to positive/negative number. It seems to be working fine, however, it doesn't convert "00000000001}" to -10. It shows as 10. This is the formula that I am using in my query: PJUNAccrual: IIf(Right([PJ_ACCRUAL_ADJ_X],1) Between "J" And...

My report was working previously with this expression: =IIf([Expr1]="BLANK","",CDate(Mid([Expr1],5,2) & "/" & Right([Expr1],2) & "/" & Left([Expr1],4))) Basically, "Expr1" is a field on the query coming from a table, which displays a date string. My expression makes the text box display the...

I had an expression which was working previously, but all of a sudden when I run the report, I keep getting a dialog box, and the object on the report gives me the "#Name" error

I want to setup a formula which shows the number of days until the due date, as well as the number of days past a due date. Not sure how to set this up on my report.

I'm trying to place conditional formatting on a report. I want the field to be highlighted if the other field displays "Technical Adjustment". My expression does not seem to be working

I have two fields: [PERSONNEL_TYPE] which contains either an R, U, P [SP_OBJ_GRP] which contains multiple number codes (031, 047, 089) The two fields are coming off of a union query, and some of the fields show the codes, but other rows show a "0" because of the way I setup the query. I want...

Does anyone know how I can convert the first column to show the number? I used the expression below, but it does not convert anything with a letter or a 0 Expr1: Val([SPPC TEST]![JULY_ACCRUAL_ADJ_X])

Does anyone know how to get this expression to work? It works by changing the numbers to correct date format, however, if the field is null, I want a blank to appear instead of "type" =IIf([DATE_APPLIED_X] Is Null,"""",CDate(Mid([DATE_APPLIED_X],5,2) & "/" & Right([DATE_APPLIED_X],2) & "/" &...

Does anyone know a way in which I can convert the strong to show the negative/positive value in the field below. I've tried using the ASC() function, but it does not seem to work. Below is what the field shows me in the query Field 1 000000000002 000000000000 00000000000K 000000000001...

I'm trying to convert a string of numbers and letters on a query, which happen to appear as: (000000000L). The field comes from a table which displays a mix of 0's and a letter at the end of the string. I'm trying to convert this into a number/value such as (-1, -2, 1, 2, etc.) Is there any...