Search results

Hello I have a table with some 20 columns one of which can have the text "yes" in it or is left blank. I would like to have a query which only shows those columns with "yes" in them. At the moment I see all the columns, those with and those without the "yes" ... By the way I changed from...

Hello I have a table with a date field in it and would like to be able to find those records which have a date in the same month as now, but 1 year ago. Is it possible to have a general query which will work regardless of which actual month is the current month? DateAdd() has been suggested...