By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,498 Members | 1,558 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,498 IT Pros & Developers. It's quick & easy.

Syntax Error Missing Operator

P: n/a
I hava a date parameter filter query but it shows error Syntax error
missing operator in query experssion
can some one please help where am i going wrong in expression

SELECT copyorderdtl * from copyorderdtl where(((cr_created_date)is
Null) and ((cr_statusupdt_date)=[Enter a Date])) OR
(((cr_created_date) is not null and (cr_statusupdt_Date)=[Enter A
Date]));

Apr 19 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Apr 19, 11:26 am, access baby <nishkr...@gmail.comwrote:
I hava a date parameter filter query but it shows error Syntax error
missing operator in query experssion

can some one please help where am i going wrong in expression

SELECT copyorderdtl * from copyorderdtl where(((cr_created_date)is
Null) and ((cr_statusupdt_date)=[Enter a Date])) OR
(((cr_created_date) is not null and (cr_statusupdt_Date)=[Enter A
Date]));
Right off the top, you are missing a dot. It should start as SELECT
copyorderdtl.* from ...

-- Larry Engles

Apr 19 '07 #2

P: n/a
On Apr 19, 1:59 pm, eng...@ridesoft.com wrote:
On Apr 19, 11:26 am, access baby <nishkr...@gmail.comwrote:
I hava a date parameter filter query but it shows error Syntax error
missing operator in query experssion
can some one please help where am i going wrong in expression
SELECT copyorderdtl * from copyorderdtl where(((cr_created_date)is
Null) and ((cr_statusupdt_date)=[Enter a Date])) OR
(((cr_created_date) is not null and (cr_statusupdt_Date)=[Enter A
Date]));

Right off the top, you are missing a dot. It should start as SELECT
copyorderdtl.* from ...

-- Larry Engles
Thanks Larry

Apr 20 '07 #3

P: n/a
On Apr 20, 7:23 am, access baby <nishkr...@gmail.comwrote:
On Apr 19, 1:59 pm, eng...@ridesoft.com wrote:


On Apr 19, 11:26 am, access baby <nishkr...@gmail.comwrote:
I hava a date parameter filter query but it shows error Syntax error
missing operator in query experssion
can some one please help where am i going wrong in expression
SELECT copyorderdtl * from copyorderdtl where(((cr_created_date)is
Null) and ((cr_statusupdt_date)=[Enter a Date])) OR
(((cr_created_date) is not null and (cr_statusupdt_Date)=[Enter A
Date]));
Right off the top, you are missing a dot. It should start as SELECT
copyorderdtl.* from ...
-- Larry Engles

Thanks Larry- Hide quoted text -

- Show quoted text -
The way to solve these sorts of problems is to build the query using
query builder, then take a look at the generated SQL. I would have
shown you how to build this statement.
-- Larry Engles
Access developer since day 1 of Access 1.0
Apr 20 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.