Proper SQL Syntax - DAO

M

MSweetG222

All -

I have reviewed the sample code at
http://www.bygsoftware.com/Excel/SQL/UsingSql.html
regarding the querying of an Access Database from Excel utilizing the DAO
library.

Below is the sample SELECT SQL Stmt from their web site:

vtSql = ""
vtSql = vtSql & " SELECT * "
vtSql = vtSql & " FROM " & ctSheet
vtSql = vtSql & " WHERE Namex Like 'R*'"

(ctSheet in the above example is Access Table Name).

QUESTIONS:
------------------
1. Instead of Field Name "Namex" I would like to query for Field Name
"Datex" greater than a particular date (say 01/01/2006). What is the proper
SQL syntax for such a request?

2. Is there something special about the field type your are requesting and
how you code the SQL string?

3. Is the WHERE SQL stmt on numeric field request different than the WHERE
SQL stmt on a date field request?

Thank you for your assistance.

MSweetG222
 
C

Crystal

Hello,

1. Datex >= #01/01/2006#
(I am assuming you meant greater than or equal to)

2.
-strings are delimited with quotes, either single or double,
as long as they match
-dates are delimited with #
-numbers are not delimited

3. only that the dates are delimited and numbers aren't
(dates are actually stored as numbers, but they are written
differently)

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top