conversion functions.

  • Thread starter Thread starter Mr. x
  • Start date Start date
M

Mr. x

Hello,
In sql query - how can I compare date column to a specific date,
i.e
select ....
where my_date_column <= "17/9/2003"
, which doesn't work ...

Besides, where can I find good help for access database (I preffer a *.chm
file).

Thanks :)
 
In sql query - how can I compare date column to a specific date,
i.e
select ....
where my_date_column <= "17/9/2003"
, which doesn't work ...
Click to expand...

You need to enter your date criterium in the "m/d/yyyy" format. Other formats,
such as "d/m/yyyy" will not be property recognized in Jet SQL.

As for help for Access, there are numerous websites where you can get help, or
links to the same, such as:

Tony Toews' Main Access Page
http://www.granite.ab.ca/accsmstr.htm

The Access Web
http://www.mvps.org/access/

And the links page at The Access Web
http://www.mvps.org/access/resources/othersites.htm
 
Where can *.chm file for database access ?

I am unaware of any CHM (html help) files that are available for additional help
in Access. You might try a search at http://www.google.com.
 
Well,
I have tried :
.... where my_date_column <= "9/17/2003".
and query doesn't work either.

Thanks :)
 
If you use Office / Access XP, there should be quite a
few .CHM files already on your computer. Search for these
files:

actoc10.chm
acmain.chm
vbaac10.chm
vbaof10.chm
DAO360.chm
ADO210.chm
JETSQL40.chm
JETDEF40.chm
MSJRO.chm
JETERR40.chm
....

There are a few more that relate to Access / Office / VBA.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top