"Detail" change to "Field0"

[jack1234]

I have a table with 3 tables, which is orderID, Detail and price.
I write a Query
SELECT * FROM [tbl];
in the result table it shows me orderID, Field0 and price(Notice Detail has changed to Field0)

How do I show Detail as it is without changing it to Field0?

Something to note:
1. I don't have right to change the table field name
2. I need to use asterick * since some columns will be added in future, and all of them need to be showed.

Thanks for the help.

 

[Moniker]

Asterisk or not, "Detail" is the name of an entire section of both a form and a report, and is therefore going to return as "field0" because of that. You'll have to get the person responsible for naming fields to change that to avoid the situation in the future.

 

[neileg]

Do you have a table level lookup on Field0? If you do, then in table view you will see Detail but in reality it's an ID field linking to another table.

This is one of the many reasons not to use table level lookups.

Edit: And Moniker has a good point about reserved words.

 

[jack1234]

What is table level lookups?

 

[Moniker]

Don't worry about what table level lookups are. You have too much on your plate as it is. (If you're that curious, open a table in design view, look in the bottom-left where Field Size, Format, etc. are. Those are on the "General" tab. Next to that is the "Lookup" tab. That's what he is talking about, but in your case, you're not using those.)

 

[Rich]

Asterisk or not, "Detail" is the name of an entire section of both a form and a report, and is therefore going to return as "field0" because of that. You'll have to get the person responsible for naming fields to change that to avoid the situation in the future.

Well that's odd, it's not listed as a reserved word in Access97

 

[Moniker]

Have you looked at a form or a report?

In a report, there's even an object called "Detail". In the View menu, you can choose to show or hide headers and/or footers, but "Detail" is ever present.

 

[Rich]

I know what a detail section is, I also know it's not listed as a reserved word, unlike date etc, although it does reproduce field0 when used in a query. Looks like Microsoft missed that one

 

[Moniker]

An easier way to tell is to open the object browser and type in the word in question. "Detail" will return a reference to each form/report you have in your DB.