IIF with 2 conditions.

[horatiu00]

Hello,

I need to bring in Table1 the MB name from MB table based on delivery date. If delivery date is between Ordering start date and ordering end date. How should i proceed? Thank you!

 

[Joe4]

First, create a Select Query on your "mb table" that selects the records that you want (see here if you need help with that criteria: Examples of using dates as criteria in Access queries).
Then, change the query to an Append Query, and write the fields you want to "Table1".

 

[horatiu00]

It works! Tks a lot!!!

 

[Joe4]

You are welcome.
Glad I was able to help!