Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Access 2007 SQL statement question

Posted on 2008-06-11
2
255 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
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 different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

839 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