Search results

Thanks for the reply. Altough I was not able to use the code excactly as you wrote it I got DLookup to accept the date by using: If IsNull(DLookup("HOLDDATE", "Holdings", "HOLDDATE = #" & Format(datadate, "mm/dd/yyyy") & "#" Then As you see I have also changed DATE to HOLDDATE as sugested by...

Hi. I'm trying to use DLookup to check wheter a specific date value is present in a table or not. The date to search for is stored in the variable datadate. The value of datadate i set by pulling the max value of a date field in a temporary table. The table i want to search in is Holdings and...