Help!!!!!....Too Few Parameters

[Guest]

Hello Everyone/Anyone...first time posting...after having gained valuable
tips from others' posts.

I didn't know which board (Access/Excel) I should have posted this query (no
pun intended) but here goes....This is a step by step account of my
pridicament:

In Access:
Step 1---I have 2 linked PRN files in a database with identical field names.
Step 2---I create a single named query dumping all fields from both linked
files (via SELECT/UNION statements) with additional field within the query
that identifies my records from each linked file.
Step 3---Query runs great, I get results I anticipate.

In Excel:
Step 3---I go into Excel and access the query data via external data source
to create a pivot table.
Step 4---Everything works fine in locating and selecting fields (I select
all fields) from the above named query....then wham...when I hit the finish
button I get the subject referenced error.

Any help would be appreciated.

 

[Douglas J. Steele]

Do you use any VBA functions in your query? If so, you cannot use the query
from outside of Access.

 

[Guest]

No VBA functions.
Just a straight dump of data from both linked files...The Pivot Table works
if I access the query without the union...meaning I'd have to pivot each
query individually.