Search results

If the user changed their name then yes the ref would also change. My query is about the how to get the default value equal to the data in the fields. I can then apply the same logic in other areas.

The field 'PRN' is the persons reference number, it's not a key field. and it will be used in correspondence - letter and emails as a shorthand way to identify indiviuals via any reply. The PRN is not related to other data.

I want a default value to equal the first 2 characters of field [first name] and first 3 characters of field [last name] and the numeric datevalue of [DOB] 'date of birth'. In excel its easy, C D E result formula Andrew Tester 12/12/1980 AnTes-29567...

Hi, I joined because MS Access SQL frustrates me and I'd welcome your help. I live and work in South East England, UK I work for the NHS as a data manager. I re-joined NHS in 2005 having previously worked in NHS 10 years earlier. THE UK NHS is the best free to use health service in the world...