access 2000 date query

Hi,

Access 2000 sql query.

Is there any way to get access to recognize '01/01/2006' as a valid date
instead of using #01/01/2006#. The database is set to use ANSI 92, I
thought that would do it.

Thanks
Bill


.

Relevant Pages

  • Re: Is there an SQL query for table schema ...
    ... > Is there an SQL query that will return a list of all indexes on a ... > In addition will it list the fields involved if it is a compound index? ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Duplicating records
    ... What kind of database? ... Bill ... For email, remove invalid. ... Prev by Date: ...
    (comp.sys.mac.databases)
  • Re: PDF image problems with FPDF
    ... What is the SQL query that you are using to retrieve images in the ... Prev by Date: ...
    (php.general)
  • fixing DM
    ... Been working on database that I initially set up as replicable. ... all the tables, queries, forms and reports as replicable objects. ... Bill ... Prev by Date: ...
    (microsoft.public.access.replication)
  • Re: Can I filter a value list in a related field?
    ... What version of FileMaker are you using? ... Bill ... > ones in Database B, ... Prev by Date: ...
    (comp.databases.filemaker)
Loading