Syntax Error Missing Operator

[access baby]

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]));

[engles]

On Apr 19, 11:26 am, access baby <[e-mail]:

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

[access baby]

On Apr 19, 1:59 pm, [e-mail] wrote:

On Apr 19, 11:26 am, access baby <[e-mail]:

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

[engles]

On Apr 20, 7:23 am, access baby <[e-mail]:

On Apr 19, 1:59 pm, [e-mail] wrote:

On Apr 19, 11:26 am, access baby <[e-mail]:

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