Hi Everyone,
I am new to using Access and need a bit of help with the below.
My DB has an end date for closed accounts. Some customers have returned and I want to remove the end date on their record. I have a added a new data source containing the customers details and all data matches. Happy with this.
I have said the following:
Field: Closed Date
Table: Customer Records
Criteria: Is Not Null And <>""
Update To: ""
Is the above going to cause any issues or is there something more accurate I can add to remove the date instead of the quotation marks?
Many thanks
I am new to using Access and need a bit of help with the below.
My DB has an end date for closed accounts. Some customers have returned and I want to remove the end date on their record. I have a added a new data source containing the customers details and all data matches. Happy with this.
I have said the following:
Field: Closed Date
Table: Customer Records
Criteria: Is Not Null And <>""
Update To: ""
Is the above going to cause any issues or is there something more accurate I can add to remove the date instead of the quotation marks?
Many thanks