Listing all fields in a query

  • Thread starter Thread starter DogmaDot
  • Start date Start date
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.
 
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

"Expr 1014" if field of query ? 3
Crashing Query Files Upon Import 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Make table query: [Enter 1] AS Test 1
Split data in field on character return 0
Queries losing fieldnames when importing from external mdb 2
Query field size quandry 2
Combine Duplicates in Query 0

Back
Top