SELECT Problem

[ukwebsite]

Please help,

I’m running an SQL statement through an Access DB the following command works fine.

SELECT * FROM Ladies_Dresses WHERE Authorised = 'checked'

I want the statement to pull out the fields where Authorised doesn’t = checked.

EG

SELECT * FROM Ladies_Dresses WHERE Authorised = ''

OR

SELECT * FROM Ladies_Dresses WHERE Authorised <> 'checked'

Each of these both produces no records. I don’t get any errors. The database can either contain the word checked or contain nothing, I have 3 records in my DB 2 have the word checked in Authorised and 1 record has nothing.

Please help?

Cheers

Matthew





Matthew Wilde
matthew@ukwebsite.com

 

[wushutwist]

SELECT * FROM Ladies_Dresses WHERE Authorised NOT LIKE 'checked';




Wushutwist


Sun Certified Java 2 Programmer