Search results

I have table that is used to collect roster information the date field is formatted dddd/dd/mm/yyyy a second field requires the end user to insert W to designate the entry as a weekend date. The end user's often forget to insert the W (not functional) I need a way to code the field to look @...

Hi I have 2003 Access Dbase from which some of the fields must be exported as comma deliminated txt and email to a repository. I need the end user to see DOB, date format dd/mm/yyyy (15/06/1959) but it must be exported as ,15061959,Town,State....etc Now I have formatted Table, Form & Query...

Hi all: I have two fields family_name & given_name.I need to extract 2nd, 3rd & 5th letters of family_name and 2nd & 3rd letters of given_name into text field called link_key. Where names do not have suffient letters for extraction then the numeral 2 is used as a replacement. Currently entering...

Hi all: MS Access 2003. I have two text fields family_name and given_name I need to extract 1st, 2nd & 5th letter of family_name along with 2nd & 3rd letter of given_name to form a link_key field. If either name has insufficient letters the missing letter is replaced by the numeral 2. Does...