DateDiff function

[orange]

You could have a table that identifies all the Contacts for a specific Contract.


Contract-->Contact
You would use the ContractID to identify all of the Contacts who should be emailed.
And for each Contact, loop through your "Send an Email" routine.


This suggests that your table and relationships dos not currently support this fact.
It is fundamental to database to ensure your design supports your business before
getting too far into programming, forms, etc.

Good luck.

[stavros]

i don't understand....

i have one table that for one contract it can be several firms that are jointly performing the contracts (multiply values).

why in query is same contract written separately for each firm in JV and how could I fix it that be written only once as in table...

[stavros]

done... :-)

only email left... when time left < 45 then sand I mail contract xy will expire within yz days....

[alansidman]

It might be helpful for you to post a copy of your database with sample data. In this manner, we are not guessing at what you are trying to explain, but can see exactly what you have and how to give you the resolution you require.