Sorry if this is a really stupid question but its got me beaten.
In table 1 I have field for "notes" into which data is occasionally entered. In table 2 I have a portal through which I can view the notes from table 1.
Problem is it's showing every record, most of which are empty. I therefore wish to filter out the empty records but I'm doing something wrong.
Could someone please help me select and build the necessary function.
Many thanks in advance.