Recent content by nashie

yay! done it. thanks! :)

ok, tried pasting the new data into my new column in the db, but the only thing i can find is paste append so it just ends up adding them on. can i paste over the original date field or at least match the new data to the appropriate record and delete the old date column???

scratch that. i got it working. thanks very much :)

mmmm, i'm getting an error saying: extra ) in query expression 'new.[CDate([Date]+[Time])]' ???

hmmmm still can't do it. i've created a new field with the hope of setting it to equal date + time... how can this be done?? anyone?? surely there must be a way to do this. i only want to put 2 columns together, its only a merge operation... :|

me access n00b. me not understand... in other words. please elaborate on what i need to do. i am not very familiar with working with access, only times i deal with it is by connecting with asp and stuff.

hmmm, well all i gotta do is clean it up and then it gets put into a SQL db. so doesn't matter what form i do this work in so i may just whack it in excel, i know how to merge in that.

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