Union Queries - Parameter Value Prompt

[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?

 

[KARL DEWEY]

Post the SQL of the union query.

 

[John Spencer]

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