Recordset SQL 2 WHERE Expressions not working
I have set up an online shop, but I only want to display those items that have not been sold and in a certain category. I can get only the category items to display, but when I add and extra where statement e.g. <> "Sold" the page does not display. I have attached a copy of the page. Can you advise where I am going wrong?
To view a functioning web page www.burtonsantiques.com.au this does not have the "Sold" filter in place only category filter.