Search results

can you merge database columns together. i have a date column and i have a time column but i need to have a 'date/time' column and therefore need to merge them together. can access do this?

i've got an access database with about 14000 records in it. theres a date field with the date in the following format: DD/MM/YY however this has got to be altered to the form: DD/MM/YYYY is there a way i can do a find and replace but only of the last 2 characters of the field? its a text...