[MS_AccessPros] Adding a IIF statement for a date query

 

I have the following query:

SELECT tblVendorTransaction.VendorTransID, tblVendorTransaction.VendorID, tlkpTransactionType.TransactionTypeName, tblVendorTransaction.BillDate, tlkpAccountType.AccountTypeName, tblVendorTransaction.Memo, tblVendorSubTrans.Amount, tblVendorSubTrans.UnitID, tblVendorTransaction.BillDueDate
FROM ((tblVendorTransaction INNER JOIN tblVendorSubTrans ON tblVendorTransaction.VendorTransID = tblVendorSubTrans.VendorTransID) LEFT JOIN tlkpTransactionType ON tblVendorTransaction.TransactionTypeID = tlkpTransactionType.TransactionTypeID) LEFT JOIN tlkpAccountType ON tblVendorSubTrans.AccountTypeID = tlkpAccountType.AccountTypeID;

This is the record source for a continuous form. On the form I have a field called txtBillDate. WHat I am trying to do is if the BillDueDate is less than todays date then in txtBillDueDate enter OVERDUE otherwise display the BillDueDate.

Is this possible?

Thanks,

Art Lorenzini
Sioux Falls, SD

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___