format date entered in one column to display as week number in ano

[mrbeepa]

Two of the columns in my table are the date of entry and the next column I
want to show the week number designated by that date. My date column is named
installDate and the other column titled signWeek. in the signWeek default
value field and in it's format field I have been trying this code:

=FormatDateTime([installDate],"ww")

When placed in the default value I get an error: The database engine does
not recognize either the field 'installDate' in a validation expression, or
the default value in the table 'contracts'

When placed in the format field this develops: first the text I entered is
reformatted into this: "=For"m"at"d"ateTi"m"e([i"ns"tall"d"ate],ww)" and I
get the same error as above about the database engine not recognizing
'installDate'.

I have verified over and over my spelling and field names?

Can someone explain to me the proper way to do this?

 

[ruralguy via AccessMonster.com]

Don't use a field for this calculated value. Simply do it in a query of the
table.

Two of the columns in my table are the date of entry and the next column I
want to show the week number designated by that date. My date column is named
installDate and the other column titled signWeek. in the signWeek default
value field and in it's format field I have been trying this code:

=FormatDateTime([installDate],"ww")

When placed in the default value I get an error: The database engine does
not recognize either the field 'installDate' in a validation expression, or
the default value in the table 'contracts'

When placed in the format field this develops: first the text I entered is
reformatted into this: "=For"m"at"d"ateTi"m"e([i"ns"tall"d"ate],ww)" and I
get the same error as above about the database engine not recognizing
'installDate'.

I have verified over and over my spelling and field names?

Can someone explain to me the proper way to do this?

 

[mrbeepa]

That's a good idea tyvm!

Don't use a field for this calculated value. Simply do it in a query of the
table.

Two of the columns in my table are the date of entry and the next column I
want to show the week number designated by that date. My date column is named
installDate and the other column titled signWeek. in the signWeek default
value field and in it's format field I have been trying this code:

=FormatDateTime([installDate],"ww")

When placed in the default value I get an error: The database engine does
not recognize either the field 'installDate' in a validation expression, or
the default value in the table 'contracts'

When placed in the format field this develops: first the text I entered is
reformatted into this: "=For"m"at"d"ateTi"m"e([i"ns"tall"d"ate],ww)" and I
get the same error as above about the database engine not recognizing
'installDate'.

I have verified over and over my spelling and field names?

Can someone explain to me the proper way to do this?

 

[ruralguy via AccessMonster.com]

You're welcome.

That's a good idea tyvm!

Don't use a field for this calculated value. Simply do it in a query of the
table.

[quoted text clipped - 18 lines]