SQL statement select instruction reserved word or argument not written correctly

[Kryst51]

Great!, can you post a jpg of your error?

Edit: Actually, why are you trying to place a query in the "order by" place?

 

[thibs27]

Do i need to have a lookup table for the query
if so
oups...

 

[Kryst51]

Do i need to have a lookup table for the query
if so
oups...

Sorry, edited my other response instead of making a new one, so this repeats my edit:

Actually, why are you trying to place a query in the "order by" place?

 

[thibs27]

Actually, why are you trying to place a query in the "order by" place?[/quote]

This is my error
Because i have en centrale and hors-centrale and im going to have 2 forms

 

[Kryst51]

OK... Obviously I don't read French, so here are a suggestion:

1.) Make sure that none of your fields contain any Access Reserved Words

Oh.... and a question, are you trying to filter the form? by the field in your query?

Can you translate "En Centrale" what are you trying to filter for here?

 

[Kryst51]

Here is some info on the orderby property, I don't know if it will help, but its better to have to much infor then not enough right?

 

[thibs27]

No access word
and yes trying to filter
Thx

 

[Kryst51]

The query JPG that you posted, of the query builder, can you change that to SQL view then post the sql from there?

 

[thibs27]

There u go
and by the way my access is really strange
half french half english
dont know y
lol

 

[Kryst51]

OK, found your problem.... Your query has three parts.

The "Select" part, The "From" part, and the "where" part....

You have stuff in the last two parts, but nothing in "Select" part. And that is because you have selected that it not be shown, which you mentioned before, but without the pics I didn't understand.


Why is that? If you are trying to get the field "TypeInstallation" not to show on your form, then you need to do that on the text box properties for tha field. Your query should have that visible.

Anyway - there has been a lot of miscommunication between us, and that's OK as long as we get your problem fixed eh? .... Check the show box on your query and see if that fixes the problem.

 

[Kryst51]

Also, I suggest making it one or the other (English OR French), so as to alleviate confusion by anyone else, including co-workers, who may look at it later. Read up on naming conventions.

 

[thibs27]

Worked great
Thx a lot

 

[Kryst51]

You are very welcome! I am glad it worked and that I could help