Access 2013 Query

I have created a query based on a table of contractors that I have. When I open up the query I get the following error:

"The Settings you entered isn't valid for this property."

I have double checked the table settings and they are all set up to be short text or number.  I have check with other revision of my database and nothing has changed.  Is there a way to fix this error before my users start working in it?  

Also I have a side question, is it possible to make a report with a drop down list so that we can print reports out per item instead of have 20 different buttons to sort them out?
kris45068Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
Delete the query
Run the compact/repair utility
Recreate the query.
If that does not work, then please post the SQL behind the query

Also I have a side question, is it possible to make a report with a drop down list so that we can print reports out per item instead of have 20 different buttons to sort them out?
This is really a separate/unrelated question that should be dealt with in a separate/new question, ...but yes, this is possible,
There is a combobox wizard that will help you create a combobox from the Items table (and include the ItemID).
...then you can use code like this to filter for the selected item
    DoCmd.OpenReport "YourReport", acViewPreview, , "ItemID=" & Me.YourCombobox
;-)

JeffCoachman
0
kris45068Author Commented:
Thanks for your reply.  I tried what you posted and recreated the query, but got the same pop up message.  Here is the SQL for the query.

SELECT ContractorNames.*
FROM ContractorNames;


I have also posted a screenshot of the Table in which I am pulling the information from.

Thanks for the help.
contractorsTable.PNG
0
Jeffrey CoachmanMIS LiasonCommented:
OK,

Lets first get you naming right.
As far as I can tell, the table name should be: tblContractors
...because it is a table of contractor fields, ...not just contractor names.

Second you have no: "ContractorNames" field in your table, ...so I am not quite sure what you were trying to do with that query...

In this case try the query like this:

SELECT *
FROM tblContractors

Works fine for me...
;-)
JeffCoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MacroShadowCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Jeffrey Coachman (https:#a40692980)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

MacroShadow
Experts-Exchange Cleanup Volunteer
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.