What am I doing wrong?
 

I know something is wrong with this select statement, but I don't know what
it is. Please help. Thank you.

Select [Inscope Table].[Date Aproved by GM PM for Invoicing],[Inscope
Table].[AT&T Extended Price] from [Inscope Table] where [Inscope Table].[Date
Aproved by GM PM for Invoicing]<"" and [AT&T Extended Price]<0

What am I doing wrong?
 

Not checked in great detail, but maybe this will work

Select [Inscope Table].[Date Aproved by GM PM for Invoicing],[Inscope
Table].[AT&T Extended Price] from [Inscope Table] where [Inscope
Table].[Date
Aproved by GM PM for Invoicing]<'' and [AT&T Extended Price]<0

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ayo" wrote in message
...
I know something is wrong with this select statement, but I don't know what
it is. Please help. Thank you.

Select [Inscope Table].[Date Aproved by GM PM for Invoicing],[Inscope
Table].[AT&T Extended Price] from [Inscope Table] where [Inscope
Table].[Date
Aproved by GM PM for Invoicing]<"" and [AT&T Extended Price]<0

What am I doing wrong?
 

The problem might be that you are attempting to compare a date field to an
empty string.

Try....

Select [Inscope Table].[Date Aproved by GM PM for Invoicing],[Inscope
Table].[AT&T Extended Price] from [Inscope Table] where [Inscope
Table].[Date
Aproved by GM PM for Invoicing] Is Not Null and [AT&T Extended Price]<0



"Bob Phillips" wrote:

Not checked in great detail, but maybe this will work

Select [Inscope Table].[Date Aproved by GM PM for Invoicing],[Inscope
Table].[AT&T Extended Price] from [Inscope Table] where [Inscope
Table].[Date
Aproved by GM PM for Invoicing]<'' and [AT&T Extended Price]<0

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ayo" wrote in message
...
I know something is wrong with this select statement, but I don't know what
it is. Please help. Thank you.

Select [Inscope Table].[Date Aproved by GM PM for Invoicing],[Inscope
Table].[AT&T Extended Price] from [Inscope Table] where [Inscope
Table].[Date
Aproved by GM PM for Invoicing]<"" and [AT&T Extended Price]<0