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.

Attached Files

Description Match.xlsx (8.7 KB, 8 views)

Does this help?

Attached Files

Copy of Description Match.xlsx (9.9 KB, 12 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Pecoflyer,

It does help a great deal. I can work on getting the two value errors resolved.

Thank you very much