error 3075 in query

[jvdpeet]

Hello,
I get error 3075 in the following query in Visual Basic 6.0:
datQueryParTest.RecordSource = "SELECT * FROM Parametertest WHERE Winst + Verlies <> 0 & Chr(34) & ORDER BY AantalPerioden, Ondergrens, Bovengrens, (Winst + Verlies)"

What is missing in this query?


Jan van der Peet

 

[MarkK]

Try...

datQueryParTest.RecordSource = "SELECT * FROM Parametertest WHERE Winst + Verlies <> 0 ORDER BY AantalPerioden, Ondergrens, Bovengrens, (Winst + Verlies)"

Cheers,

 

[jvdpeet]

Thank you lagbolt for your reply, but this gives the same error.


Jan

 

[jdraw]

Just a thought ---

Are all of the fields really in table Parametertest ?
Are they spelled correctly?
Is it possible that Winst + Verlies is NULL?

 

[gemma-the-husky]

is it the orderby parameter (Winst + Verlies) that is the issue. It seems an unusual usage. Take this out and see if it works.

Indeed, construct a visual query, and see what the SQL looks like.

 

[Red17]

There should be no ampersand symbol before the ORDER BY statement.

Try this

datQueryParTest.RecordSource = "SELECT * FROM Parametertest WHERE (Winst + Verlies) <> (0 & Chr(34)) ORDER BY AantalPerioden, Ondergrens, Bovengrens, (Winst + Verlies);"

 

[jvdpeet]

Thank you Red17. I removed it and the result is the same.

Jan