what is wrong with this select statament: select [all items]![For

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

[all items] is the name of my database table.
I want to select the only the fields listed in the select statement from my
table [all item] if the field signature has '*jason*' the stament reads"
select [all items]![Form Name],
[all items]![Back-of-Page Form],
[all items]!Subsystem,
[all items]!Signature,
[all items]!Description
where [all items]!Signature LIKE '*Jason*'
the error message I received reads:
Syntax error (missing operator) in query expression '[all items]!Description
where [all items]!Signature LIKE '*Jason*''.
 
You don't have a FROM statement. Try this:


SELECT [all items]![Form Name],
[all items]![Back-of-Page Form],
[all items]!Subsystem,
[all items]!Signature,
[all items]!Description
FROM [all items]
WHERE [all items]!Signature LIKE "*Jason*"
 
Syntax error (missing operator) in query expression '[all
items]!Description where [all items]!Signature LIKE '*Jason*''.
Click to expand...

And there is no bang operator in SQL. In any case, if this is a single
table you can get rid of all the table name qualifiers:

SELECT [Form Name],
[Back-of-Page Form],
Subsystem,
Signature,
Description
FROM [All Items]
WHERE Signature LIKE "*Jason*";



.... and I would have a real long look at your object (i.e. tables and
fields) naming system.

All the best


Tim F
 
Back
Top