ldDate = DATE() ldYearBeg = DATE( YEAR(ldDate),01, 01) ldYearEnd = DATE( YEAR(ldDate)+1,01, 01)-1 SELECT * ; FROM receivables ; WHERE Programcode = lcProgramcode ; AND receivables.TranDate Between ldYearBeg AND ldYearEnd ; TO SCREEN NOCONSOLE IF _TALLY > 0 *There is at least one record for this year ELSE *No records for this year ENDIF>I have a receivables table that I want to add information too but can't figure out how to do it. Here are the rules to adding to it. I have customers who are either billed annually or monthly. They have a program code. It is marked in the program table as either monthly or annually.