Solved

Access 2007 SQL statement question

Posted on 2008-06-11
2
253 Views
Last Modified: 2011-10-19
i'm trying to write a simple query in access 2007 but it returns the attached error

what the heck am i doing wrong? i'm sure it is some syntax error

thanks
sqlerror.bmp
0
Comment
Question by:RunToTheHills
  • 2
2 Comments
 

Author Comment

by:RunToTheHills
ID: 21759861
sorry

forgot to put the code in there

SELECT *
FROM Files
WHERE Files.Name = 'John Zawod';
0
 

Accepted Solution

by:
RunToTheHills earned 0 total points
ID: 21759938
nevermind i figured this out on my own
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question