Query Left Inner Join and Null Data?

[mahenkj2]

Last solution to use "Last" was to get the latest record in list. Now you need to show only the contracts which are not expired,is it correct?

Yes, then you have to set a criteria telling access to show date ends only if it is newer than current date. something like

HAVING ((Last(Tbl_Contracts.DateEnds)>Date())

 

[luism]

LAST works to a certain degree, especially if there are multiple Contracts (as much as 10 or more from many years ago) then LAST fails.

I want it to show Contracts that have either expired (only if all of them have expired of course and the latest one, like 12/11/2011)

But most of all to show Contracts that will expire anytime after today. Including next months, or even years.

I have not been able to successfully achieve this yet

 

[luism]

Another option would be to do something like this

All contracts expired before today's date to say "Expired"
All contracts to end anytime today or after today to show the date it will expire.

I dont know if that makes it easier.

 

[luism]

May have to give up on this interface, I tried and just cannot get it to work *sigh*