Forum Discussion
Unable to run the queries in Ms access
Hi guys, I am Gilbert Fernandes. I am facing difficulties in running the queries in access database. There are three tables: OrderTemp , OPS$OMAUTH_OMA_WAREHOUSE_ORDER and Tbl_SERVICE_ORDER ...
Sorry, but that's a really hairy query, sort of intimidating to try to parse out.
So, in general, make sure all of those parameters are properly delimited for the datatype involved.
Numbers require NO delimiter.
Strings of text require the text delimiter: "
Dates require the date delimiter: #
Inspect each of your parameters in turn, comparing the syntax to the underlying datatype.