C
Chuck W
Hi,
I have a table called tbl3T that has two fields. One is called DisDate
which is a text field with date in them in the format of 03312008, 12082007
etc. I have a separate field called NumericMonth which is blank. I want to
create an update query using the left function that will take the left two
characters from DisDate and populate the NumericMonth field with these
values. Can someone help?
Thanks,
I have a table called tbl3T that has two fields. One is called DisDate
which is a text field with date in them in the format of 03312008, 12082007
etc. I have a separate field called NumericMonth which is blank. I want to
create an update query using the left function that will take the left two
characters from DisDate and populate the NumericMonth field with these
values. Can someone help?
Thanks,