Bill4tektips
Technical User
I have 3 date fields in a table and I need to find which one is the latest to form the basis for a report. The 3 Fields are [CorrPCD], [RemPCD] and [LatestPCD]. I have tried various combinations in a query but have so far failed. I need to improve my sql skills. My last attempt was:
LatestPCD: IIf([tblNonConformances]![RemPCD]>=[tblNonConformances]![LatestPCD], [tblNonConformances]![RemPCD] Or IIf([tblNonConformances]![CorrPCD]>=[tblNonConformances]![RemPCD],[tblNonConformances]![CorrPCD],[tblNonConformances]![LatestPCD]))
Can anyone help please?
LatestPCD: IIf([tblNonConformances]![RemPCD]>=[tblNonConformances]![LatestPCD], [tblNonConformances]![RemPCD] Or IIf([tblNonConformances]![CorrPCD]>=[tblNonConformances]![RemPCD],[tblNonConformances]![CorrPCD],[tblNonConformances]![LatestPCD]))
Can anyone help please?