| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What am I doing wrong | Excel Discussion (Misc queries) | |||
| Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
| Where am I going wrong? | Excel Programming | |||
| Where am I going wrong? | Excel Discussion (Misc queries) | |||
| What's wrong with this? | Excel Programming | |||
Linear Mode
