<> in a query

[Guest]

Hi all,

I have a query that ,when i try to input the criteria <>"Not a case",it
loads and displays the query in chart view,and if i copy and paste this
criteria from another query,the rows that are hidden are the ones that i
don't need to hide.
Which kind of problem is it?




SELECT customersupport2.Serial, customersupport2.sr,
customersupport2.Subject, customersupport2.gdate, customersupport2.Sender,
customersupport2.[Original message], customersupport2.Status,
customersupport2.[E-mail], customersupport2.Pick, customersupport2.[Customer
type], customersupport2.Comments, customersupport2.Type,
customersupport2.[Receiving Method], customersupport2.AHT,
customersupport2.Month2, customersupport2.Livello, customersupport2.Livello2,
customersupport2.Tipo, customersupport2.Autotime, customersupport2.Atuotime2,
customersupport2.Code2, customersupport2.Restime, customersupport2.Resagent,
customersupport2.Restxt, customersupport2.Description, customersupport2.SR2,
customersupport2.Esccode, customersupport2.Agent, customersupport2.Answer,
customersupport2.Time, customersupport2.serial2
FROM customersupport2
WHERE (((customersupport2.gdate)>#11/23/2006#));

 

[John W. Vinson]

Hi all,

I have a query that ,when i try to input the criteria <>"Not a case",it
loads and displays the query in chart view,and if i copy and paste this
criteria from another query,the rows that are hidden are the ones that i
don't need to hide.
Which kind of problem is it?




SELECT customersupport2.Serial, customersupport2.sr,
customersupport2.Subject, customersupport2.gdate, customersupport2.Sender,
customersupport2.[Original message], customersupport2.Status,
customersupport2.[E-mail], customersupport2.Pick, customersupport2.[Customer
type], customersupport2.Comments, customersupport2.Type,
customersupport2.[Receiving Method], customersupport2.AHT,
customersupport2.Month2, customersupport2.Livello, customersupport2.Livello2,
customersupport2.Tipo, customersupport2.Autotime, customersupport2.Atuotime2,
customersupport2.Code2, customersupport2.Restime, customersupport2.Resagent,
customersupport2.Restxt, customersupport2.Description, customersupport2.SR2,
customersupport2.Esccode, customersupport2.Agent, customersupport2.Answer,
customersupport2.Time, customersupport2.serial2
FROM customersupport2
WHERE (((customersupport2.gdate)>#11/23/2006#));

Where are you trying to put this criterion - on which field? Your SQL does not
HAVE that as a criterion. Please explain a bit more about this query - we have
no way to know which field you're looking at, what it contains, or what
results you expect!

John W. Vinson [MVP]

 

[Guest]

Hi,
The field is customersupport2.Status

Hi all,

I have a query that ,when i try to input the criteria <>"Not a case",it
loads and displays the query in chart view,and if i copy and paste this
criteria from another query,the rows that are hidden are the ones that i
don't need to hide.
Which kind of problem is it?




SELECT customersupport2.Serial, customersupport2.sr,
customersupport2.Subject, customersupport2.gdate, customersupport2.Sender,
customersupport2.[Original message], customersupport2.Status,
customersupport2.[E-mail], customersupport2.Pick, customersupport2.[Customer
type], customersupport2.Comments, customersupport2.Type,
customersupport2.[Receiving Method], customersupport2.AHT,
customersupport2.Month2, customersupport2.Livello, customersupport2.Livello2,
customersupport2.Tipo, customersupport2.Autotime, customersupport2.Atuotime2,
customersupport2.Code2, customersupport2.Restime, customersupport2.Resagent,
customersupport2.Restxt, customersupport2.Description, customersupport2.SR2,
customersupport2.Esccode, customersupport2.Agent, customersupport2.Answer,
customersupport2.Time, customersupport2.serial2
FROM customersupport2
WHERE (((customersupport2.gdate)>#11/23/2006#));

Where are you trying to put this criterion - on which field? Your SQL does not
HAVE that as a criterion. Please explain a bit more about this query - we have
no way to know which field you're looking at, what it contains, or what
results you expect!

John W. Vinson [MVP]

 

[John W. Vinson]

The field is customersupport2.Status

Ok, that's the field. My other questions still stand:

Please explain a bit more about this query - we have
no way to know ... what it contains, or what
results you expect!

Is Status a Lookup field?

John W. Vinson [MVP]