Search results

arnelgp I tried your suggestion. Select tblO.ClNr, tblO.DateList FROM tblO WHERE(((tblO.DateList=Date() ))) UNION Select tblO.ClNr, tblO.DateList FROM tblO WHERE(((tblO.DateList=Date()-1 ))); The result is not what I need ClNr DateList 10 24-10-2017 10 25-10-2017 12...

Minty this is a short example of my table ClNr DateList 10 24-10-2017 12 24-10-2017 14 24-10-2017 18 24-10-2017 20 24-10-2017 10 25-10-2017 12 25-10-2017 16 25-10-2017 18 25-10-2017 Today (25-10-2017) ClNr 16 would be new on the list and ClNr 14 and 20 would be "solved"

Hi Sneuberg I tried your suggestion to enter the comma. The result was the same, same error. I had already found the site you suggested and tried according to what I understood of these examples. Since I am not familiar with nested queries I probably did not understand the examples.

I have searched through the threads here but could not find an answer to my problem. I have no experience with nesting queries and I think I need a nested query. I have a table that is filled daily with around 600 records containing amongst others client numbers, balances and the date a record...