Automatic Deletion of Cells

[Refereejohn]

I have 11 Columns if I wanted to have three cells automatically delete after three months yet keep the remainder of the row how could I achieve this? I will have a date of birth, first name and last name to remove but keep the rest of the information in the row.

[pbaldy]

Sounds odd, but you could run an update query that set the value of those fields to Null or whatever, with the appropriate criteria.

[Refereejohn]

Thank you for your welcome reply. The updates to First Name, Last Name & Date of Birth field have to be between dates ordered. When I attempted the Update Query I could not get the data to pull through with the dates I had listed EG Between #1/1/2016# and #31/6/2016#. Does anyone have any suggestions?

[pbaldy]

Shot in the dark, but try putting the date in US format.

[Missinglinq]

Odd is an understatement, but Paul's correct about needing dates in US format in Queries. Allen Browne has an excellent article explaining this:

International Dates in Access

Linq ;0)>