Tax Exempt in a Query - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Tax Exempt in a Query

Neal Austin

10 months ago

I need help with this query i have, when i run it, i get enter parameter value, CustomerT.TaxExmpt, where i need to manually add in a value, any way to write this query without changing what it does on my forms, but have it not ask me for the value?

	Neal Austin OP @Reply 10 months ago

	Kevin Robertson @Reply 10 months ago
Your CustomerT is not part of this Query. You will need to add it.

	Richard Rost @Reply 10 months ago
Ah, the classic Enter Parameter Value.

	Neal Austin OP @Reply 10 months ago
ok i will work on that, thanks

	Neal Austin OP @Reply 10 months ago
when i do add the CustomerT table, to that query, then non of my data shows up, if i try to change the join properties, i get ms access error for ambigous outer joins. any ideas?

	Richard Rost @Reply 10 months ago
You might have to add the customer table as a second query. Take the query that you got now and make that the data source in a new query. Then add the customer table to that query, and you should be able to join them.

	Neal Austin OP @Reply 10 months ago
ok, i will try, thank you

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View