SQL statement select instruction reserved word or argument not written correctly (2 Viewers)

[thibs27]

Hi,
I'm having problems while adding a query to a form by sql statement
I enter the field that i want to use a query on and it is saying to me, while i quit and save, that in the select instruction, a word is reserved or an argument is not written correctly or not there, or that the punctuation is not correct?
How can I resolve this problem?
THX

 

[Kryst51]

Post your exact code so we can see what you have.

 

[thibs27]

The thing is that i dont have any code
Im just doing it in the form
by opening the properties, u can have a sql statemtn attached to ur form
Thats it
Thx

 

[Kryst51]

You say you are adding via an sql statement in your original post? what is that SQL, sorry I used the wrong term.

 

[thibs27]

Im adding a field thats contained in the table my form is based on
im just removing the show option and adding a criteria
Thats it
Thx

 

[Kryst51]

Im adding a field thats contained in the table my form is based on
im just removing the show option and adding a criteria
Thats it
Thx

OK, I'm glad you found a workaround

 

[thibs27]

Didnt
Thats where i get my error
when trying to exit and saving thats where it tells me that error

 

[Kryst51]

Didnt
Thats where i get my error
when trying to exit and saving thats where it tells me that error

OK then,

I don't get this sentence"

Im adding a field thats contained in the table my form is based on

based on what? EDIT: Nevermind, I read the sentence wrong.

im just removing the show option and adding a criteria

I don't know what you mean by this sentence either.

What SQL are you using? What are you trying to do? Post your db minus any sensitive info.

 

[thibs27]

here we go
i am designing a form that gets all the fields form a big table
then, i hit the properties of the form
it tells me if i want to add a query to that form
i say yes
it tells me its an sql statment
then, i get 1 field from the table that is used in the form
i deselect the show option and i put in a criteria so the query for this field is still there
then i try to save and quit
then i get this eror
Thx

 

[Kryst51]

Heh, That is so hard to visualize, Can you post your db, and explain the end result..... What is the purpose of this form, and what is the purpose of the field you are adding.

 

[thibs27]

Do you know what im talking about the sql statement?

 

[Kryst51]

You haven't posted anything to help me help you! I asked you to POST YOUR SQL STATEMENT earlier. You didn't. POST YOUR SQL STATEMENT! I DON'T KNOW WHAT YOU ARE TRYING TO DO, BUT HAVE ASKED YOU TO POST YOUR STATEMENT, have asked you to clarify what you are doing, I CANNOT HELP YOU IF YOU DON"T ADEQUATELY ANSWER MY QUESTIONS. <I am not yelling, just emphasizing.>

 

[thibs27]

Post my SQL statement?

 

[Kryst51]

Post my SQL statement?

At the very beginning you say this:

I'm having problems while adding a query to a form by sql statement

what is the sql statement.

 

[thibs27]

It just tells me that its an sql statement
i dont really know what it is
its just when i had a query to a form by clicking on the form properties

 

[Kryst51]

It just tells me that its an sql statement
i dont really know what it is
its just when i had a query to a form by clicking on the form properties

Than please post your db minus any sensitive information so I can see what is happening.

 

[Kryst51]

Your query can be viewes as an sql statement, can you open your query, change to sql view then post that here?

 

[thibs27]

Ill get back to u 2morrow for this
im not sure if i have the right to post my db
lol
working for a company

 

[Kryst51]

That's why you remove sensitive info...... but, are you able to open the query you are using?

If you are able, go into SQL view copy and paste what you find into a quotes window on here. (See the JPEG attached called "SQL view example)

If you are talking about the filter on a form (See the JPEG attached called "fileter view") then post whatever is in the box in your db for that option.

 

[thibs27]

Here are some screen shots
I get the error while saving the query
Thx