Query acting funny *

[Acke]

Hi!

I think my queries started to act strange.

First problem is when I select several fields from a table and then go to SQL, it always has a comma and a * at the end of the first row.

For example:
SELECT Id, FieldX, FieldY, *
FROM...
Normally it should be:
SELECT Id, FieldX, FieldY
FROM...

If * and comma are deleted from SQL, everything works fine. It is just there as default.

Second problem is if I want to add number, or data value from a form to a query, it returns funny squares or other funny symbols. I have to create additional control on a form, to copy problematic data format to string and then successfully use it in query.

As I remember it was not happening before. All my prior queries are without “comma *” end. Not absolutely sure about second problem, but I think I was able to use any data format from a form in a query. What is wrong??? Did I turn some feature ON, or OFF???

Thanks!

 

[namliam]

Dates should get / have ## around them, shoudlnt be anything strange there...

The * thing is probably to do with the default adding of the * DOES NOT HAPPPEN...
The * has to have been added manual and will remain there untill removed manually. No feature, no nothing, manual error.

 

[Acke]

Dates should get / have ## around them, shoudlnt be anything strange there...

It also happens with number data types. I can use all text data types. Also, if I combine data or number data with text data, I have no problem. Not sure if this is normal behavior for query.

The * has to have been added manual and will remain there untill removed manually. No feature, no nothing, manual error.

Exactly that is strange to me. It happens automatically. All new queries I am trying to make automatically add “comma *” end. I have to go to SQL to delete it every time I make new query.