Ummm...I see what I think are a couple of problems.
But you need to tell us what the DATA TYPES are for those fields in you Access DB:
*SURELY* sdate is a DATETIME column? No? If not, it clearly SHOULD be. You will never be able to do queries such as "get me all records added in the last month" unless it is. If it *is* DATETIME, then your syntax for a date value ('08062013') is utterly wrong. If it's not, fix it.
And surely sold and set are numeric fields of some kind???? If so, then you can't put '...' around values intended to be stored in a numeric field. (MySQL allows such sloppiness; Access is smarter than MySQL here and doesn't.)
Finally, I think maybe that set is a keyword in Access SQL. If so, that's no big deal, but then you need to put the name in [...] to tell Access to treat it as a column name and not a keyword.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.