I am attempting to develop a query for a report using four fields as the drive for the query. The fields are
taxpayerID integer
DateLtrSent date
DateLtrDue date
DateResponded date
The issue is I need to evaluate the three dates for each record and output the following
taxpayerID
latest of the three dates
I am trying to establish a stored query for use within vba. Not use of the best approach so I am trying some different methods. Any suggestions would be helpful.
Using windows 8.1 and 7 using Access 2010.
Thanks
Rod
__._,_.___
Posted by: desertscroller@cox.net
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar