Solved

Access 2007 SQL statement question

Posted on 2008-06-11
2
249 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
Comment Utility
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
Comment Utility
nevermind i figured this out on my own
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now