For example, I have records I need to tie to data in a crosstab query. In the query there is a conversion table that converts date to "OctRate". I'd like to use Switch("OctRate", [OctRate]). But that doesn't want to work.
Any suggestions to return the value in a field in an unrelated table where the query refers to the column name? Thank you.