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 actually figured out what was casing the error. Apparently, whenever I set an event procedure, in this case it was an event procedure "on activate" which automatically maximizes the report, it causes an error. I got rid of the event procedure to maximize the report, then there were no...

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

Thanks, this worked great. I appreciate the help.

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

Thank you, I will check this out tomorrow.

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

Thank you, I appreciate your help.

the main table which contains this field is coming from the mainframe (PDB2), the field itself in business terms represents a numeric value used for rounding. If someone enters a spending plan total amount on the screen of the actual program, they use the field to put a small amount such as -1...

The field comes from a data table which I am pulling from with Access.

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])

I was actually able to manipulate the query, and somehow got it to work. Thank you.

Unfortunately it did not, I'm trying to figure this out. Any other ideas?

Yes this is a report. After I typed in the expression you provided, I then changed the format to short date.

I highlighted the original field as it appears in the first column, then the second column is what I get when I use your statement. It works partially, but does not show me a blank when the [DATE_APPLIED_X] field is blank. Instead it displays "Type!"

Thank you, I tried this, but I'm still getting the same results. It does not seem to be working. Any other ideas?

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