Change wording after date passes

[landor]

Hi,
I am helping put together a database for my HR department. I have a form
which shows details of current job vacancies in our organisation. It shows
the job as active until the closing date for applications.

Is there a way I can change the criteria (active) to 'completed' after a
date has passed without having to manually go through every job vacancy and
doing it manually?

Thanks in advance

C

 

[Jeff Boyce]

Take a look at an "Update" query (check Access HELP).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[landor]

Thanks Jeff,

Sorry to sound thick (but if the cap fits....) I have looked in Access help
but am unsure of what criteria to input. The two fields I have are 'vacancy
status' (which displays either active or completed and a field for the
closing date. so hypotheticaly if a vacancy closes on 2/2/2009 i want the
vacancy status field to change to completed.

Can you help?

Cheers again

 

[Jeff Boyce]

If I'm understanding your description, you want your query (start out as a
select query) to find any record that has [VacancyStatus] equal to something
other than "completed", and a [ClosingDate] that is earlier than today's
date.

I'd use
<>"Completed"
under the [VacancyStatus] field in the query, and
<Date()
under the [ClosingDate] field in the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[landor]

Brilliant!! works a treat!!

Many many thanks Jeff

C

If I'm understanding your description, you want your query (start out as a
select query) to find any record that has [VacancyStatus] equal to something
other than "completed", and a [ClosingDate] that is earlier than today's
date.

I'd use
<>"Completed"
under the [VacancyStatus] field in the query, and
<Date()
under the [ClosingDate] field in the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks Jeff,

Sorry to sound thick (but if the cap fits....) I have looked in Access
help
but am unsure of what criteria to input. The two fields I have are
'vacancy
status' (which displays either active or completed and a field for the
closing date. so hypotheticaly if a vacancy closes on 2/2/2009 i want the
vacancy status field to change to completed.

Can you help?

Cheers again