Union Queries - Parameter Value Prompt

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

I would like to combine information from two tables with identical data
fields into one. I have used a UNION query. One of the fields contains
numerical data (with decimal). When I run the query, I get a popup box
asking me for a "Parameter Value". When I run the Query, the same
information I put in for the parameter shows up in the field. What is it
expecting for me to do?

In addition, I would like to further manipulate the data after the query so
that it SUMS the resulting data according to company name WHERE the numerical
data is >500.

Can someone help?
 
If you are getting an unexpected parameter value prompt, it usually means that
you have misspelled a field name in the SQL statement or entered a
non-existent field name.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Back
Top