Dynamic Year field in table

[Ebes1099]

How can you create a field in a table that contains the year, but changes dynamically with the turn of the calendar? I've tried the now() function and that doesn't seem to work.

The premise of this is that I have a separate table that contains a year and a salary value, in the table I'm trying to get the dynamic year field in each row is a record of a worker and I want to pull over the salary for them based on the data in other table dependent on the year field.

 

[SkipVought]

hi,

What you describe is done in a QUERY, not in a table.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[lameid]

And the expression you would use in the query to get the current year would use the year function and I would recommend the date function instead of now for this purpose....

Year(Date())

How you use this depends on the table(s) involved and what you are trying to do.

 

[dhookom]

I'm not sure I understand but you can create a field in table design and provide a default value of:
=Year(Date())


Duane
Hook'D on Access
MS Access MVP