acccess 2007 (1 Viewer)

ShiftZZ

LIFE MEMBER
Feb 19, 2008
21,383
84,579
Dark Side of the Moon
Funster No
1,546
MH
A class
Exp
Since 2007
I haave a large database and I have imported a large number of records, the only this was I forget to add a date, so all the data records are blank.

Is there a way of changing a blank field into to days date?



Ta

ShiftZZ
 

johngee

Free Member
Aug 19, 2009
57
0
Hampshire, UK
Funster No
8,060
MH
Coachbuilt
Exp
Since July 2009
Create an update query. Type 'create an update query' in Help if you need to. You can update the field you specify from blank/null to whatever. You may need to look at the design of your table to ensure that the blank field is in a date format. If not, change it.

Subscribers  do not see these advertisements

 

Join us or log in to post a reply.

To join in you must be a member of MotorhomeFun

Join MotorhomeFun

Join us, it quick and easy!

Log in

Already a member? Log in here.

Latest journal entries

Funsters who are viewing this thread

Back
Top