Recent content by ahti098

specially that part where I could get the results for "return first Seamans, if not Passport, if Not ID Card"

thanks but seems that my knowlege is still lacking to fully understand what you meant. could you illustrate a little

I have DocExpiry table where Employee name comes form Employee table and DocType comes from DocType table. Therefore in the DocExpiry table the value is 3 from table DocType IDDocType what is the Primary key. Problem is that doc type 3 what is Seamans passport cant be empty or 0 .In the table...

Sorryy could not figure right now out a better way to atach This nr 3 in DocType get me employee records with seamaspass but if he does not have seamanspass I would like to get rcords with Passport instead and if Passport is also missing then records with IDCard

Hi I have a table for employee documents including field doctype. Doctype is linked to another table Doctypes from which the corect document type an be selectes Passort or ID card. Also a query based on that. I can make the query to chose records based on criteria so that for example only...

Hi I am Ahti not new to Acess but still unfortunately on a basic level