By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

Problem with Parameter Query

P: 1
I have created a query asking to calculate a third number using two fields in the query. However when I run the query I get a enter parameter query box asking me to enter information on one of the fields when the information is in the query.

My question is how do I remove this request box when I didn't create it as a parameter, as I just want it to carry out the query action using data in the query cells.
Jan 8 '08 #1
Share this Question
Share on Google+
1 Reply


JKing
Expert 100+
P: 1,206
Hey there,

The enter parameter box usually occurs when you have mistyped a field name and the query cannot recognize the field as existing.

Alternatively if you have forgotten to declare the table from which the field belongs to you would also receive the same parameter box.

My suggestion is to carefully examine all field names and ensure that they are spelt correctly and match the spelling of the actual field names in the tables.

If that does not solve your problem please post the SQL of your query so we can further help you.

Jking
Jan 8 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.