<div>
If you are using the asterisk ( * ) to view all fields in a table, and specifying this field as well, then you'll have it in there twice. &nbsp;
</div>


If you are using the asterisk ( * ) to view all fields in a table, and specifying this field as well, then you'll have it in there twice.  

<div>
Such a quick and correct set of answers many thanks.<br />
<br />
I trust splitting the points os OK<br />
<br />
Regards<br />
<br />
John Hardy
</div>


Such a quick and correct set of answers many thanks.

I trust splitting the points os OK

Regards

John Hardy

<div>
Split 'em as you see fit. &nbsp;Experts collaborate on answers all the time. &nbsp;Good luck with your project. -Jim
</div>


Split 'em as you see fit.  Experts collaborate on answers all the time.  Good luck with your project. -Jim

<div>
&quot;Expr1001&quot; is displaying at fields which is already declared for example &quot;Address&quot; that shows like &quot;Expr1001&quot; while declaring duplicate field name &quot;Address&quot;.<br />
Note:<br />
1).Address field was created in table.<br />
2).Create same field&quot;Address&quot; using Aliase &quot;Address&quot; then previous field name change as &quot;Expr1001&quot;.
</div>


"Expr1001" is displaying at fields which is already declared for example "Address" that shows like "Expr1001" while declaring duplicate field name "Address".
Note:
1).Address field was created in table.
2).Create same field"Address" using Aliase "Address" then previous field name change as "Expr1001".

<div>
<div class="content wysiwyg-content">
I have an access Table. <br />
In the table<br />
The second field RefNo is a text field 50 - not required - allows zero length.<br />
<br />
I have this in a Select Query<br />
Inthe Design View of the query RefNo shows correctly.<br />
When I look at the details (ordata) View RefNo shows as Expr1001<br />
<br />
Any ideas why please?
</div>
</div>


I have an access Table. 
In the table
The second field RefNo is a text field 50 - not required - allows zero length.

I have this in a Select Query
Inthe Design View of the query RefNo shows correctly.
When I look at the details (ordata) View RefNo shows as Expr1001

Any ideas why please?

Access Query Expr1001

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.