I'd agree with
@arnelgp .
David - create a blank new database.
Import all the objects in your current database into the new one.
You will need to recreate any relationships you created, and any file specific option things (open specific form on database open etc)
[/QUO
I'd agree with
@arnelgp .
David - create a blank new database.
Import all the objects in your current database into the new one.
You will need to recreate any relationships you created, and any file specific option things (open specific form on database open etc)
The issue occurs in any database, new or not, if I try to do this as part of a query in a query grid. It does not occur if I use DateAdd in VBA. No matter which database (current or new blank one) I use, the problem is exactly the same. Its very confusing so I can only conclude there is something fundamentally wrong with my Access installation and not with the specific databases. It seems like the issue won't go away so I will have to use a VBA somehow to produce the variable and insert it into a query. Thanks for all the help and advice, much appreciated