Ignoring null fields

[FlyingCrane]

Hi,

I have a table called TSRDatabase (mind the missing prefix conventions).
It contains 6 columns:
[Name], [T], [Date], [T_Link], [L], [L_Link]
[Name] is the primary key.

Is there a way I can display all data in [L] that does not contain NULL values? I would like to display all data in the [L] column (but no NULL values), as well as the corresponding [T], [T-Link], and [L-Link] values.

Is this possible?
Thanks.
Crane

 

[Pampers]

You could make a query...

Pampers
Just back from holiday...
that may it explain it.

 

[ThomasLafferty]

Create a new query. Add the TSRDatabase table to the design grid. Drag all fields that you wish to see onto the design grid row area. On the Criteria row of the L field, type the following expression:

[COLOR=blue]Is Not Null[/color]

To run the query, click the red exclamation mark on the toolbar [!]![/!] or Click Query>Run.

Hope this helps.

Tom

Live once die twice; live twice die once.