Thanks for your reply Wayne as im stuck with this one..
ok, i'm not given any errors actual Access Errors as such, it just fails to display the text "**avaliable**" at the start of the query, the query looks to run ok when on it's own, but when i display it on a Form in a List Box all the other...