Listing all fields in a query

D

DogmaDot

When I create a new query and pull in an existing query, all that shows is a
* and all the fields in that query are not listed. When I open a query based
on a query, in some the fields show up and in some they don't and the fields
have Expr in front of them.
 
K

KARL DEWEY

the fields have Expr in front of them.
If the names are duplicated then that is how Access distinguishes apart.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
QBF & Query Malfunction 0
Creating a Chart on form from selected data in query. 0
Template with fields and premade texts.. 0
Make table query: [Enter 1] AS Test 1
Need some PWA help 0

Top