LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
James T
 
Posts: n/a
Default Syntax Error in Excel Query for DATE field

I have created an excel query using ODBC, and linking to a financial software
products tables.

I am attempting to enter in a criteria to reduce the number of records
returned.

I am trying to put in a criteria against a DATE field. However when in
enter in a date and run the query I get the following error "Syntax Error".

Can someone help??


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error message in Excel after exporting Access query to Excel Romi Excel Discussion (Misc queries) 0 June 6th 05 02:53 PM
Excel Query Wizard Date Format aldsv Excel Discussion (Misc queries) 1 May 31st 05 12:44 PM
Help with Charting My Data -- DavidM Charts and Charting in Excel 7 January 7th 05 01:08 PM
New web query with Excel Pro Edition 2003 Chandler Links and Linking in Excel 2 December 15th 04 06:03 PM
Excel Query Via Sybase Gary Excel Discussion (Misc queries) 1 December 7th 04 07:58 PM


All times are GMT +1. The time now is 12:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"