Thank you

it's all making sense now. fields are only supposed to have one entry.

Thank you all again

Paul M

Thanks for your help.

So to normalise the table do I need to remove the commas? What about spaces? and is it possible for instance to have "non figure"...

Hi

Thanks for replies. removing the wildcards was the first thing I tried but this resulted in "no records found" which is strange because i have other statements without the wildcards...

Thank you Eirikur for your reply, but your request for more information is way over my head. I am using an access database as a gallery for my...