Jim, No, that won't work because the expiredate column is in a lookup table. Thanks.
>>> [EMAIL PROTECTED] 11/13/01 04:18PM >>> Bob Can't you just do a PRINT RptName WHERE ExpireDate IS NULL Jim Limburg Bob Powell wrote: > > Hello everyone: > > I have a table that contains three rows. There is a column in the table that allows >me to enter an expiration date for any row, thus allowing me to eliminate it from >selections etc. if so desired. One of the rows currently has an expiration date the >other two rows do not. > > I have a report that is connected to said table. I have also defined a variable in >the reoport as follows: > > vCourse = ActNickName in Activities whe ActID = ActID and ExpireDate is NULL > > The variable is in the display seciton of the report and a break is set on Id number. > > The reports prints the correct two rows from the table that have no expiration date >and a blank row for the row that does have the expiration date. Is there a way to >keep the report from printing the blank row? > > I realize that I can project another temp table with only rows that have no >expiration date and then run the report from that table but I was wondering if there >was a way to "automatically closeup" the blank spaces on the report. I also know >that I might be able to do something like that with the label generator. Any idea's ?
