What would be the function to check if an item is in a table

[galsaba]

I need to write a query that will result "false" or "true" whether or
not the item is on a list. let's say I item=123. and I have a list. I
NEED TO check if item 123 is on that liat.

thanks

galsaba

[Fred Zuckerman]

"galsaba" <ga*****@aol.com> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...

I need to write a query that will result "false" or "true" whether or
not the item is on a list. let's say I item=123. and I have a list. I
NEED TO check if item 123 is on that liat.
thanks
galsaba

Check out the Dlookup() function.
Fred Zuckerman