I have two tables in Access 2010 (database4 is attached) with test data. One table contains agents by code and the amount of commission they earn for selling product "WLLB". The other table contains commission levels by date. Commission contracts change over time and we are reconstructing some really old data for export to a newer system (for records purposes).
I need to create a query to return records where:
3) [CommLevelsByDate].ANBTo = 70 AND
tDate => [CommLevelsByDate].ValidFr
om and <=[CommLevelsByDate].Valid
The result set would be: [AgentTestRecords].Agt as AgentCode, [CommLevelsByDate].Produce
rTier as ProducerTier, [CommLevelsByDate].ValidFr
om as CommScheduleDate and [AgentTestRecords].Contrac
tDate as ContractDate
So, I know what I want but I am in over my head on doing something that looks like a union with a bunch of conditionals versus my simple select query experience. Thanks in advance for any help!