Search results

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...