Simple exclude Null records problem

[ZOR]

I am trying to prohibit records that are empty in the Shot field. Below not working or multiple variations tried. Thanks

& "WHERE (TXCLIPS.Shot)>"") and Trim(TXCLIPS.NName) Like '*" & Replace(Me!LNAME8.Caption, "'", "''") & "*' " _

 

[PHV]

You may try this:
& "WHERE Trim(TXCLIPS.Shot & "")<>"" AND Trim(TXCLIPS.NName) Like '*" & Replace(Me!LNAME8.Caption, "'", "''") & "*' " _

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ZOR]

Thanks PHV, query does not give output?

 

[ZOR]

i still cannot get a list containing records having a filled field Shot.

Me.L8.RowSource = "SELECT TXMASTERS.Barcode, TXCLIPS.NNAME AS Name, TXCLIPS.Comments, " _
& "TXCLIPS.Start AS TimecodeIn, TXCLIPS.Duration, TXMASTERS.SportorSports AS Sport, " _
& "TXCLIPS.StarRating, TXCLIPS.Shot, TXMASTERS.SeriesName AS Programme, " _
& "TXMASTERS.EpisodeTitle AS Episode, TXMASTERS.Competition" _
& " FROM (TXMASTERS INNER JOIN TXCLIPS ON TXMASTERS.ID1=TXCLIPS.ID1)" _
& "WHERE TXCLIPS.NName & ' ' Like '*" & Replace(Me!LNAME8.Caption, "'", "''") & "*' " _
& "ORDER BY 2"


Sorry the query has got bigger from last time.

The last suggestion stopped query output. Many thanks

 

[ZOR]

Managed to solve it, using:
& "AND ((Not (TXCLIPS.Shot) Is Null))" _

Thanks