Query to display values not present in table...

[blondends]

Hi,

I need to produce a query that will only ouput the values that are not present in a table. The example is...

I have a dropdown box which will be used to select 1 of 3 times (06:00, 15:00 and 23:00) - but I want it to only show times in the dropdown which are not contained in a record for that specific day already.

I hope that makes sense, thanks in advance,

Chris

 

[Remou]

Do you mean something on the lines of:


Select From tblTimes Where Time Not In (Select Time From Appointments Where Date=Date())