Search results

Dear Doc_Man, I already have this field in the Programmes table. I just don't know how to write the correct formula that you are suggesting...

IIf([Programme ID]='EFAW-GR' Or [Programme ID]='EFAW-ENG' Or [Programme ID]='EPFA-GR' Or [Programme ID]='EPFA-ENG' Or [Programme ID]='FAW-ENG' Or [Programme ID]='FAW-GR' Or [Programme ID]='MEDTEC-ENG' Or [Programme ID]='MEDTEC-GR' Or [Programme ID]='MG-ENG' Or [Programme ID]='MG-GR' Or...

IIf([Programme ID]='EFAW-GR' Or [Programme ID]='EFAW-ENG' Or [Programme ID]='EPFA-GR' Or [Programme ID]='EPFA-ENG' Or [Programme ID]='FAW-ENG' Or [Programme ID]='FAW-GR' Or [Programme ID]='MEDTEC-ENG' Or [Programme ID]='MEDTEC-GR' Or [Programme ID]='MG-ENG' Or [Programme ID]='MG-GR' Or...

First I would like to thank everyone for helping! I will take some screenshots and show you what the problem is.. Thank you again

I am sorry if i am using wrong words. I am new in Access. What i mean with link is the the field programme id is linked with relationship with the table programmes. So the programme id is a drop down list and shows all the records in programmes table

The programme field is linked with another table and there is a drop down list to avoid mistakes. Is there an alternative to this calculated field?

Sorry for late reply! This is the formula i used. Is there an alternative to the calculated field? IIf([PROGRAMME]="ΠΡΩΤΕΣ ΒΟΗΘΕΙΕΣ ΣΤΗΝ ΕΡΓΑΣΙΑ - ΕΠΕΙΓΟΝΤΑ ΠΕΡΙΣΤΑΤΙΚΑ" Or [PROGRAMME]="ΠΡΩΤΕΣ ΒΟΗΘΕΙΕΣ ΣΤΗΝ ΕΡΓΑΣΙΑ",[ISSUE DATE]+1094,IIf([PROGRAMME]="ΚΑΡΠΑ ΚΑΙ ΧΡΗΣΗ ΑΥΤΟΜΑΤΟΥ ΕΞΩΤΕΡΙΚΟΥ...

Hello again, I tried a few nested iif statements but without any results. It said that there was a syntax error.

Hello, I would like to add a formula on the Expiry Date field that will automatically add 1 or 3 years on the Finish Date field depending on the Programme ID.

Hello. My name is Paul and i live in Cyprus. I am new in Access and i am making a database for my training school! Have a nice day:)