Hi All,
I have a query which gets a list of records from a table. Each record will, among other things, contain the details of a person and in most cases this will include a Social Security type number (SSN) for the format [0-9]{6-12} (thats all numeric length 6-12).
I need to have a calculated field which tells me, based on SSN how many previous records are in the database for that SSN. The issue is that sometime people are putting in NIL, Unknown, UNK etc.
So before preforming the calculation I need to check that whats in the SSN field is not null, and matches pattern. I don't think this can be all done in SQL?
Ultimately the query is sent to a report.
How can I achieve this in Access?
Thanks
Al
I have a query which gets a list of records from a table. Each record will, among other things, contain the details of a person and in most cases this will include a Social Security type number (SSN) for the format [0-9]{6-12} (thats all numeric length 6-12).
I need to have a calculated field which tells me, based on SSN how many previous records are in the database for that SSN. The issue is that sometime people are putting in NIL, Unknown, UNK etc.
So before preforming the calculation I need to check that whats in the SSN field is not null, and matches pattern. I don't think this can be all done in SQL?
Ultimately the query is sent to a report.
How can I achieve this in Access?
Thanks
Al