I have a series of appointment dates in a table for a particular person. I have already selected the person using other data. I now want to add the next appointment date that falls after the current date. lets say I have 06/01/01, 06/15/01, 06/28/01, and 07/02/01 and my report date is 06/20/01. What would be the selection formular to select and print 06/28/01? Any help would be much appreciated.
Thanks
Harold
Thanks
Harold