user3791372
Reputation: 4665
Access SQL - How do I return a boolean if a joined row exists or not
I'm putting together a query for the datasource for a tabular form. Amongst other data, I want to show a checkbox if a row exists in a joined table and return it as a field for the checkbox to bind to.
Can the boolean be retrieved with one query, or will it have to be a fudge with VBA?
Upvotes: 0
Views: 349
Answers (1)
Krish
Reputation: 5917
You must use an outer join and perform iif(isnull(field), true_value, false_value)
Upvotes: 1
Related Questions
- Access 2016 - Return TRUE if Item exists in Table, False if Item is Missing
- Return true (1), if a joined data entry exists, else false (0) in MS-SQL
- Access 2007 query to not cut-off records if one particular join doesn't exist
- Return True if specific value exists in table - sql
- Return records even if they don't exist in the joined tables
- SQL - Check if data exists on either table
- Need query to return Null fields if no associated data in joined table
- Selecting joining records where all rows have a field equalling false
- How can a query return 'yes' if a matching record exists and 'no' if not? SQL / MS Access
- How can I return a list of records and true or false if a joined record exists using SQL?