Index using multiple conditional tests
Greetings,
I have to pull a description from a table using multiple conditions to identify the correct entry. The table with the descriptions has a store start and stop date and time. The table requiring the description has a transaction start and stop date and time.
I want to test the transaction store number to equal the store number, transaction start date and time to be greater than or equal to the store start date and time, and the transaction end date and time to be less than or equal to the store end date and time.
Attached is a file with some sample data.
Any assistance would be greatly appreciated.
|