Hi, I have a couple of tables which stores a colour value and a size value as colours and sizes are both options it also seems to store a null size value for each colour.  I am trying to retrive just the record for the colour and the size value of null (as I dont want all the size details), however I cannot for the life of me just extact this record where the sizeval is null.  When I just select the colour I get each size and record for the null, so I know it is there!  Any help woudl be appreciated.  Thanks

Hi, thanks so much, I think that worked!