Posted to microsoft.public.excel.programming

James W.[_2_] James W.[_2_] is offline

external usenet poster

Posts: 31

Trouble with select statement

I recorded a query... works great without the variables

This is within a select statement
Time<={ts '2005-04-19 01:00:00'})

However when i change the date to capture my dtpicker value i get nothing
returned. arghh

Time<={ts '" & Format(Criteria1, "yyyy-mm-dd") & " 01:00:00'}

Any help is greatly appreciated

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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
Trouble constructing IF statement	Joe[_13_]	Excel Worksheet Functions	1	February 9th 09 06:16 PM
Trouble with an IF statement.	Cerberus	Excel Discussion (Misc queries)	3	February 18th 08 09:29 PM
If statement trouble	Carlee	Excel Worksheet Functions	3	May 28th 07 10:13 PM
Trouble with a conditional statement	Jim	New Users to Excel	2	April 10th 05 10:13 PM
SELECT statement	Tom Ogilvy	Excel Programming	2	July 23rd 04 06:24 PM

All times are GMT +1. The time now is 10:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us