What is wrong with this Select Statement

[Ayo]

I keep getting a syntax error (missing operator) message and I can't figure
out what is wrong.

"SELECT * FROM [InScope Table] WHERE ((([Extended Price])<>0) AND (([Funding
Request Status])="Approved") AND (([AT&T Extended Price])=0)) AND [Project
Number]=062G4311 AND [Task Number]=3000"

 

[Dirk Goldgar]

I keep getting a syntax error (missing operator) message and I can't figure
out what is wrong.

"SELECT * FROM [InScope Table] WHERE ((([Extended Price])<>0) AND
(([Funding
Request Status])="Approved") AND (([AT&T Extended Price])=0)) AND [Project
Number]=062G4311 AND [Task Number]=3000"

Is that a quoted literal string? It has quotes inside the quotes (around
"Approved"). If that's the problem, you can use single-quotes (') inside
the literal instead of the double-quotes:

"SELECT * FROM [InScope Table] WHERE ((([Extended Price])<>0) AND (([Funding
Request Status])='Approved') AND (([AT&T Extended Price])=0)) AND [Project
Number]=062G4311 AND [Task Number]=3000"

 

[Ayo]

I did that and it didn't work. Still got the same message.

I keep getting a syntax error (missing operator) message and I can't figure
out what is wrong.

"SELECT * FROM [InScope Table] WHERE ((([Extended Price])<>0) AND
(([Funding
Request Status])="Approved") AND (([AT&T Extended Price])=0)) AND [Project
Number]=062G4311 AND [Task Number]=3000"

Is that a quoted literal string? It has quotes inside the quotes (around
"Approved"). If that's the problem, you can use single-quotes (') inside
the literal instead of the double-quotes:

"SELECT * FROM [InScope Table] WHERE ((([Extended Price])<>0) AND (([Funding
Request Status])='Approved') AND (([AT&T Extended Price])=0)) AND [Project
Number]=062G4311 AND [Task Number]=3000"



--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Jeanette Cunningham]

Ayo,
the bit that is wrong is the quotes around Approved.
try
'Approved'

or

""Approved""

Jeanette Cunninghan

 

[Dirk Goldgar]

I did that and it didn't work. Still got the same message.

I just noticed another thing. You also need quotes around "062G4311":

"SELECT * FROM [InScope Table] WHERE ((([Extended Price])<>0) AND (([Funding
Request Status])='Approved') AND (([AT&T Extended Price])=0)) AND [Project
Number]='062G4311' AND [Task Number]=3000"

 

[Ayo]

Neither worked. The problem seem to be centered around this section WHERE
((([Extended Price])<>0) AND (([Funding Request Status])="Approved") AND
(([AT&T Extended Price])=0)) AND [Project Number]=062G4311 AND [Task
Number]=3000
IAnd I can't figure out what the missing operator is.

Ayo,
the bit that is wrong is the quotes around Approved.
try
'Approved'

or

""Approved""

Jeanette Cunninghan

I keep getting a syntax error (missing operator) message and I can't figure
out what is wrong.

"SELECT * FROM [InScope Table] WHERE ((([Extended Price])<>0) AND
(([Funding
Request Status])="Approved") AND (([AT&T Extended Price])=0)) AND [Project
Number]=062G4311 AND [Task Number]=3000"

 

[John W. Vinson]

Is that a quoted literal string? It has quotes inside the quotes (around
"Approved"). If that's the problem, you can use single-quotes (') inside
the literal instead of the double-quotes:

and since Project Number is a Text field it needs quotes too:

"SELECT * FROM [InScope Table] WHERE ((([Extended Price])<>0) AND (([Funding
Request Status])='Approved') AND (([AT&T Extended Price])=0)) AND [Project
Number]='062G4311' AND [Task Number]=3000"

If Task Number is also Text instead of Number, it will also need quotes.

John W. Vinson [MVP]

 

[Jeanette Cunningham]

Perhaps the Task number is a text field also?

Try "SELECT * FROM [InScope Table] WHERE [Extended Price]<>0"

if that bit works without the error then try
"SELECT * FROM [InScope Table] WHERE [Extended Price]<>0 AND (([Funding
Request Status])='Approved')"

if that bit works without error try

(([AT&T Extended Price])=0)) "

Jeanette Cunningham

Neither worked. The problem seem to be centered around this section WHERE
((([Extended Price])<>0) AND (([Funding Request Status])="Approved") AND
(([AT&T Extended Price])=0)) AND [Project Number]=062G4311 AND [Task
Number]=3000
IAnd I can't figure out what the missing operator is.

Ayo,
the bit that is wrong is the quotes around Approved.
try
'Approved'

or

""Approved""

Jeanette Cunninghan

I keep getting a syntax error (missing operator) message and I can't
figure
out what is wrong.

"SELECT * FROM [InScope Table] WHERE ((([Extended Price])<>0) AND
(([Funding
Request Status])="Approved") AND (([AT&T Extended Price])=0)) AND
[Project
Number]=062G4311 AND [Task Number]=3000"

 

[BruceM]

I'm not going to claim any great expertise with SQL, but I have noted that
there are parentheses here:
AND (([Funding Request Status])='Approved')
but not here:
AND [Project Number]='062G4311'
It looks to me from the double parentheses as if this statement was the end
of the SQL:
AND (([AT&T Extended Price])=0))
and then you added two more conditions, but after the double parentheses.
These observations are on top of those already mentioned about text fields
in quotes.

Perhaps the Task number is a text field also?

Try "SELECT * FROM [InScope Table] WHERE [Extended Price]<>0"

if that bit works without the error then try
"SELECT * FROM [InScope Table] WHERE [Extended Price]<>0 AND (([Funding
Request Status])='Approved')"

if that bit works without error try

(([AT&T Extended Price])=0)) "

Jeanette Cunningham

Neither worked. The problem seem to be centered around this section WHERE
((([Extended Price])<>0) AND (([Funding Request Status])="Approved") AND
(([AT&T Extended Price])=0)) AND [Project Number]=062G4311 AND [Task
Number]=3000
IAnd I can't figure out what the missing operator is.

Ayo,
the bit that is wrong is the quotes around Approved.
try
'Approved'

or

""Approved""

Jeanette Cunninghan


I keep getting a syntax error (missing operator) message and I can't
figure
out what is wrong.

"SELECT * FROM [InScope Table] WHERE ((([Extended Price])<>0) AND
(([Funding
Request Status])="Approved") AND (([AT&T Extended Price])=0)) AND
[Project
Number]=062G4311 AND [Task Number]=3000"