How to test of record exists in table?

[tdaccess]

Is there a way to determine if a record exists in a table with SQL syntax? If the recode does exists, I want to return "T". If the record does NOT exists, I want to return "F".



Thanks,

[ajetrumpet]

td,

is there a reason for all of the questions all of a sudden?

[tdaccess]

Been away from Access for a long time and getting reoriented for a few task that I need to complete.

[ajetrumpet]

to test for existence in a table, you need a record indentifier and the "IN" subquery. You can also use the EXISTS subquery clause.