Forum Discussion
Query problem in Access
Hello George,
I see what you mean about uservoice. I don't understand what you mean about - The next step is to verify that no other parameters exist in this query. The following is the names in file: we have 3 names beginning with C.
I have 2 relationships Events ID, Locations, and Volunteers. They are to location Id and Volunteer numbers only. Is it possible you could look at my computer. i am a novice at most of this,
Thank you,
Tena_Younger As a volunteer participant in this forum, I would not be willing to do any sort of remote connection, sorry. The risk is too great for both of us to have either of us getting access to other people's computers, IMO.
Can you open this query to SQL view and copy the entire SQL Statement and paste it here? That'll be the quickest way, I think.
What we're looking for in addition to the WHERE clause is any JOINS between tables, or if there is only one table in the query.
Since I did not understand what you were asking me to do, I called my computer person and he told me to do the following:
I don't see the parentheses in front of select. Does this help with the info you were looking for?
Sorry, let's step back a bit further. I want to see the actual query that is giving you trouble. I believe in your initial screen shot you should a few columns from a table called "Volunteer". That's the query we need to work with. Do you still have it saved?
Can you find the original one and open it in design view? It should look like your first screen shot at that point. Now I need you to change to SQL view from the query design grid view.
When you see the SQL, copy it completely and paste it here.
Thanks.