I'm sure it's quite simple, perhaps so simple that non of the millions of tutorials I've read can bear to spell it out, but someone has to...<BR><BR>I can't construct a simple query. I've tried various ways, trying to adapt the samples I've seen to do something which is much simpler.<BR><BR>When I write "SELECT * FROM Database WHERE field = "value"" it tells me that it thought the line had ended, and every other variation I've tried, including making "value" a variable without ""'s and surrounding the ""'s with ##'s, won't work either. Surely it's not that complicated???<BR><BR>I would also like to count the number of records that fit the query first. Is there a way of doing this?<BR><BR>Many thanks for your help.