How to convert thisSQL Statement into a format the MS Access 2003 will accept

D

DJM2

Basically I want to write a Between statement in MS Access Design View.

The database is number format. 'yyyymmdd hh24:mi:ss'

This works in Excel but not in Access.

FROM
ODS.TRANSACTION_FACT t3

( t3.TRANSACTION_TIME_LOCAL >= (to_date((to_char(sysdate-31,'yyyymmdd')||'
'||to_char('23:59:59')),'yyyymmdd hh24:mi:ss' ))
and t3.TRANSACTION_TIME_LOCAL <= (to_date((to_char(sysdate-1,
'yyyymmdd')||' '||to_char('23:59:59')),'yyyymmdd hh24:mi:ss'))
 

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

How do I convert number to a date format in MS Access 3
Convert Oracle function INSTRC in MS ACCESS or SQL Server 3
How do I convert a database "serial format date" to a calendar dat 1
MySQL query conversion to MSAccess 2003 query for report 10
HOW TO SAVE DATA IN ACCESS & ORACLE TABLE FROM VISUAL BASIC FORM 1
how to convert database written in Turkish MS Access to English MSAccess 2
Need query to pull out string in field - Access97 (newbie to Access 97) 1
convert MS Access databases 97 to 2003 1

Top