Avatar of pdvsa
Flag for United States of America

asked on 

Date and IF statement


I need a formula that will return the [tblLetterOfCredit.ExpireyDate] for the first record but then for all else then return the [tblPayments.PaymentDate].
Where clause is tblLetterOfCredit.LCID = tblPayments.LCID and I think the formula would need to reference [tblPayments.ID] somehow.  

It would be better to see the attached pared down db.
There are 2 tables and 1 query only.

Here is a screenshot of what I am looking for:
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon