Ben, Thanks so much for your solution. Although I hate to admit it, I've never used a sub-select in printing a report. Opens up a who new world. Thanks.
>>> [EMAIL PROTECTED] 11/13/01 09:11AM >>> Print rptName whe actID in (sel actID from Activities whe expireDate is Null) order by yadayada Ben Petersen On 13 Nov 2001, at 16:47, Bob Powell wrote: > 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 ? > >
