Forum Discussion
Tena_Younger
Jun 08, 2020Copper Contributor
Query problem in Access
I am taking a college course of Access and my instructor told me what to do and I checked various ms access videos and was told the same info. Everything is going haywire with my office Access 365. ...
George Hepworth
Jun 10, 2020Steel Contributor
Okay, you corrected the problem with the ANSI 92 SQL syntax and you are still not getting results from the query with the appropriate syntax.
The next step is to verify that no other parameters exist in this query. (I've had that happen myself. You can't see all of the columns in the query in the query design grid because they are off to the right, not showing.)
If you can verify that, and still no results, please confirm that there are actually records in the table which have last names starting with C.
And finally, verify that the query is based on a single table (Volunteers), or if it joins Volunteers to another table that the result of that join to additional table(s) doesn't eliminate those records which would otherwise be returned.
Tena_Younger
Jun 10, 2020Copper Contributor
I spoke with someone in Microsoft and he saw the problem. Yes there are names in access which begin with C and still not working. He put me in touch with uservoice. I'll see what happens there.
Thank you,
Tena
- George HepworthJun 11, 2020Steel Contributor
Tena_Younger HOW did this support person "see" the problem?
You should be aware that UserVoice is NOT intended to be a place for requesting support or reporting problems. It is a place where you can submit suggestions or requests for new features in Access. I am not too confident that an Access support person who sent you there for this problem really has all that much relevant experience.
But you didn't address the possible reasons I offered for one particular query not to return the desired records. One was that there might not be values in the field that match your criteria. But the other is that you may be joining two (or more) tables in the query which results in the records you want not actually being available. Can you show us the ENTIRE SQL from this query?
Thank you.