stuck

[nval005]

I'm sure this is basic for everyone but I forgot how to lists all the records except 1 record.

SELECT * FROM table WHERE ????

hmmm im stuck. Thanks in advance!


The table records advices made by users. it has Author, I want to list all advices except the one the author made. thanks

 

[nval005]

ok I found this one

Select * from Users Where UserId<>10

but how do I put this into the Criteria? I'm using the MSAccess query...

i tried <> "username" but no go ?



------

FAR OUT !!! ..... its ok now...thinking too much that the solution is in the front of me!!!

soln: <> "username" grrrrrrrrrrr