Search results

I thing we have the solution. This tip really worked out. I want to thank you for your time, you really help me at my work!:)

As it is evident when i use the semicolon, Access adss a "switch \", which returns an error message. :banghead::banghead: expr1: DateAdd("\y";5;[Datentry])

The field is definetely a date, the problem is at expression syntax where comma is not accepted. But anything else, changes the expression in a way that returns an error. :banghead::banghead: I don't know if there are any Access settings that define the manipulation of comma or semicolon

I know it sounds weird but i've tried all possible combinations

I've tried, no result, same answer

Thank you for the reply I am from Greece. When i try to use ; Access changes the original expression to this : Expr1: DateAdd('\y';5;[Datentry]) which returns an error result when i run the querry

Hello I am trying to use the dateadd function in an expression in a computed querry. What i am trying to do, is to use this function, to create a collumn that increases the date of a table's field (DateEntry), for five years. The syntax is Expr1: DateAdd('y',5,[Datentry]) but it seems that...