Okay, I am not sure if this belongs in the table section, but it is dealing with the data of tables.
I am looking for a way to click a button and have information from a table deleted if it has been in the DB for more than 3 years (not sure the time frame yet, but lets just go with that for now). I have no information on how to accomlish this but I am open to any and all ideas. I just do not want the user to have to input a date, as that is when things will get sticky, some people where I work tend to type numbers into the DB incorrectly.
I have a way to delete empty fields using this (which was going to be part of my question):
CurrentDb.Execute "DELETE * FROM tablenamehere WHERE fieldnamehere Is Null;"
I am looking for a way to click a button and have information from a table deleted if it has been in the DB for more than 3 years (not sure the time frame yet, but lets just go with that for now). I have no information on how to accomlish this but I am open to any and all ideas. I just do not want the user to have to input a date, as that is when things will get sticky, some people where I work tend to type numbers into the DB incorrectly.
I have a way to delete empty fields using this (which was going to be part of my question):
CurrentDb.Execute "DELETE * FROM tablenamehere WHERE fieldnamehere Is Null;"