when i open my query in excel does not show all the fields

**masoud_sedighy** · 09-04-2017, 07:27 AM

i have a query like below picture, it consists of 4 queries, one main query (qryDocumentSummary) and 3 others query beside that is related to main query.

now when i open query in MS Access it shows all the fields and it has no problem.
also when i export to excel from MS Access it shows all the fields and is okey. now when i open this query in excel, it does not show all the data fields from other queries and just show fields related to (qryDocumentSummary). please help what is the problem.

Click image for larger version.

Name: open_to_excel.jpg
Views: 6
Size: 226.3 KB
ID: 30193

**JoeM** · 09-04-2017, 08:31 AM

How exactly are you trying to open the Access query in Excel?

when i open my query in excel does not show all the fields

Thread Tools

when i open my query in excel does not show all the fields

Similar Threads

hi experts in access db data feiles is there but when i refresh from excel those fields is not show

If I can see fields in a query, why would they not show up on the form?

How to have certain fields show/not show in a query depending on another field parameter

Certain Fields only show #Name? until I run the Record_Source query.

Macro runs query that exports to Excel, now how to open additional Excel Workbooks?

Posting Permissions