Recent content by BobK

Thanks, the full stop was the issue but the colon is fine and would be common in a parameter. However, it does not ask the user for the parameter and gives "error 3061 Too few parameters. Expected 1"

I am running this query from VBA code: SELECT * FROM tblWalkers WHERE tblWalkers.RefNo>=[First ref no.:] AND tblWalkers.walk5K=""1""; It gives error 3126 Invalid bracketing of name '[First ref no.:]' Why is this - what is wrong?