Recent content by Bob_Mackenzie

Thanks all for your thoughts. I am a self taught amatuer which explains the dreadful naming conventions. I will try renaming the fields. I can confirm that although the ASW union calls functions it runs perfectly well on its own without errors, I only get the error when its joined to the ships...

Hi All. I am tearing my hair out at this one. Access 2012 The query in the first pic runs fine, and will run fine with all the fields as long as I don't add 0nn or 0qun to the query Once I add 0nn or 0qun to the query it get an ""Invalid argument to function" error. The data in 0nn is the...