First off, some definitions of what I'm working with:
BalanceFE is a table of lots of policy numbers, dates, balances, etc.
Sheet1 is a table that includes only a few policy numbers.
Sheet2 is a table that includes only a few dates.
I would like to be able to search BalanceFE for the balances of those specific policies on those specific dates. Well, not exactly. I actually want all policies except
those specific policy numbers to show up.
I can achieve the "date" sort with the following code:
SELECT BalanceFE.Policy, BalanceFE.Product, BalanceFE.Date, BalanceFE.Ballance, BalanceFE.Price
FROM BalanceFE, Sheet2
[Note: I know I could perform both the date and policy queries in a single query, but I've separated them for the time being for simplicity and troubleshooting.]
Now I want to search the above query, call it Query1, for all account numbers except
those listed in Sheet1. The following code does not
SELECT Query1.Policy, Query1.Product, Query1.Date, Query1.Ballance, Query1.Price
FROM Query1, Sheet1
Thanks for any help you can provide, I'll be happy to clarify any questions.