Pre filter data or add custom value with a query within another query?

[dreid1011]

I have tried to look this up a little bit already, but I don't think I can word it properly to find what I am looking for. Anyways, this is what I would like to know:

Is it possible, through a calculated field or sub query, to add a value to query results based on a specific value in each record?

Ex: I would like to run a query on our database to return all properties in an area. Each property has a specific tax code assigned, which can be used to determine if the property is within city limits or without. What I would like to be able to do is use a sub query within my main query to analyze the tax code for each property and then assign one of two values to a new field that would display with the main query results.

Sure, I could do this in excel with a custom formula or some VBA, but it would be much more convenient if I could do it at the time of export. Is this possible? Maybe even some VBA in access that could be called when I need it?

Thank you!

 

[welshgasman]

Have a table with the tax code and your value, then link to that table.
Use a DlookUp() on same table (will be slower)
Use and IIF() function if simple calculation, else create your own function if complicated.

 

[dreid1011]

Ah, yes, a new table with just the tax codes and the values I want to see is a much simpler solution than I was making it out to be. No lookups or functions required. Thank you.