Proper SQL Syntax - DAO

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
strive4peace2006@yahoo.com


MSweetG222 wrote:
> 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
>

Crystal,

Thank you so much.
I understand.

Thx
MSweetG222



"Crystal" wrote:

> 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
> strive4peace2006@yahoo.com
>
>
> MSweetG222 wrote:
> > 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
> >
>