While you can create a calculated field in a query (thus you could create that field/column), you can't get any data from a field that doesn't exist in a table. Assuming that this is only about one field and the table names don't change, consider using code to test if the field exists and run one query if so but another one if not.
Not sure what you want to do with that field in a query if it's not in the linked table.
Last edited by Micron; 05-02-2022 at 08:29 AM.
Reason: added comment
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.