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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Do you use any VBA functions in your query? If so, you cannot use the query
from outside of Access.
 
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.
 
Back
Top