Recent content by star777

Hi Colin, you are right that I am a kind of messed up. I use the code: IIf([LOEVM]="X" Or [SPERR]="X" Or [SPERM]="X" Or [SPERQ]="PA" Or [SPERQ]="PD" Or [SPERQ]="PE" Or [SPERQ]="QF" Or [SPERQ]="QG" Or [SPERQ]="QH",1,0) works great however the value properties is an issue now. you suggested to...

Hi Colin, Thank you. Yes but problem is not solved. Could you please have a look? please find the file attached.

For the selected vendors: A) if at least one of the indicators LOEVM, SPERR, or SPERM ="X", set COMPANIES.DISABLED to "1" ELSE B) If SPERQ = one of the values below: PA (Vendor Moved) PD (Block for Duplication) PE (Block for Commercial Issue) QF...

it work good thank you very much. But how do I set COMPANIES.DISABLED. Can I create new field with dot(.)? And also I want to show value PA with description (Vendor Moved) For the selected vendors: A) if at least one of the indicators LOEVM, SPERR, or SPERM ="X", set COMPANIES.DISABLED to...

Hi Thank you. yes it is field. but i have show the description instead of "PB" etc

Hi Thank you again. no idea how to do that. new programmer!

Hi Minty, Thank you. This is just an example. It is a huge table with huge records. Is it possible? How?

No problem, Sir! Whenever you can please . Thank you.

In a query! not clear to me. Could you add an example please?

Hi Colin, Thanks again. As you see the SPERQ column contains only PA not (Vendor Moved)! I would have to show (Vendor Moved) instead of PA where applicable. is it possible? For the selected vendors: A) if at least one of the indicators LOEVM, SPERR, or SPERM ="X", set COMPANIES.DISABLED to "1"...

Hi, Thank you. Yes valid data. if SPERM="X" it must be 1 in the COMPANIES.DISABLE column.

Hi Colin, how do i get B) If SPERQ = one of the values below: PA (Vendor Moved) PD (Block for Duplication) PE (Block for Commercial Issue) QF (Disapproved) QG (Inactivated) QH (Unapproved) i mean instead of PA i must show (Vendor...

Hi Thank you. Yes it is independent.

Hi Colin, Thanks a lot. I will try if then first. if it does not work i want to try 1. Select Case statement 2. A Lookup table could you please help me with that. thanks . LifeSaver!

Hi All, I am a new member on this site. Could you please help on this problem. For the selected vendors: A) if at least one of the indicators LOEVM, SPERR, or SPERM ="X", set COMPANIES.DISABLED to "1" ELSE B) If SPERQ = one of the values below: PA (Vendor Moved) PD (Block...