Hi Access Forum,
I have a select query that joins two tables. Table A has all records and Table B has dates relating to some records of Table A. When I use criteria to select dates =Date()-365 I get all records where the date is older then 1 year and no null dates.
But... I still need the Null entries as in my opinion they are more then 365 days old.
How would I construct the criteria to select all null records and all other records where the date is today -365???
Appreciate any support. Regards, Bill:confused:

The criteria could be:

Is Null Or >= Date()-365

Thanks Bob, works well. Regards, Bill:)

oops.. should be Is Null Or <Date()-365 or <=Date()-365.
The option with >=Date()-365 returned records where repayments have been made in last 12 months and where no repayment has been made. Thanks again Bob.