Recent content by djai695

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?