W
Wombat
I'm an Access newbie and trying to build a report for a DVD Database. The
report I'm trying to build has text boxes for Program Name, Actors, Year and
Genre.
Not all the of the Year and Genre feilds are populated and whent the report
gets to one of the unpopulated feilds it adds that record but doesn't go on
to the next one. I've setup default values for new dvd entries however I'm at
a loss as to how to get around my current problem for the existing records.
I've tried using the =IIF(Isnull([Genre], " ",[Genre]) however that just
returns an "#Error" message in the report.
Any help greatly appreciated, Thanx in advance, JJ
report I'm trying to build has text boxes for Program Name, Actors, Year and
Genre.
Not all the of the Year and Genre feilds are populated and whent the report
gets to one of the unpopulated feilds it adds that record but doesn't go on
to the next one. I've setup default values for new dvd entries however I'm at
a loss as to how to get around my current problem for the existing records.
I've tried using the =IIF(Isnull([Genre], " ",[Genre]) however that just
returns an "#Error" message in the report.
Any help greatly appreciated, Thanx in advance, JJ