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

Listing all fields in a query 0
"Expr 1014" if field of query ? 3
Query with too many fields 7
Query shows all fields... 3
Make table query: [Enter 1] AS Test 1
Fields in a query 4
Use In() Expression as Query criteria with guts from Function 1
query several fields 5

Top