UPDATE Tracks SET Tracks.AlbumName = "Mama Tried" WHERE ((Tracks.Cat)=572 AND (Tracks.Track)=3 AND (Tracks.Disk)= );
The problem is Tracks.Disk is a numeric field and is sometimes a number but other times a null.
If I use Nz function it becomes a string but then my query crashes if quotes are used.
I'm sure there must be a solution bur I can't quite work it out.