Can a field in a table be the default value of another field?

I created a table with a field name of Start Date.

There are a number of queries and html pages set to get the data in that
field.

I want to create another field in the same table called StartDate without
the space and have it equal the value in the Start Date field. This will
buy me time will I fix all of the pages and queries.

Is this possible?

I tried entering = Start Date in the default value of StartDate which
returned = "Start Date"

Thanks in advance

It's not possible unless you're using a form.


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Dave" wrote in message
...
I created a table with a field name of Start Date.

There are a number of queries and html pages set to get the data in that
field.

I want to create another field in the same table called StartDate without
the space and have it equal the value in the Start Date field. This will
buy me time will I fix all of the pages and queries.

Is this possible?

I tried entering = Start Date in the default value of StartDate which
returned = "Start Date"

Thanks in advance

You could try to create a query from that table, create an extra field
StartDate:=[Start Date] and then Make Table From Query.
However, if you are using Access 2003, and it is not an Access Project, look
for the
Show Property Update Options buttons on your options dialogue box, it may
save you a bunch of time.
Pilar

"Dave" wrote:

I created a table with a field name of Start Date.

There are a number of queries and html pages set to get the data in that
field.

I want to create another field in the same table called StartDate without
the space and have it equal the value in the Start Date field. This will
buy me time will I fix all of the pages and queries.

Is this possible?

I tried entering = Start Date in the default value of StartDate which
returned = "Start Date"

Thanks in advance