Anniversary Dates

[brag89]

Hi

I am running a database that as a 'commencement date' for a contract and a 'termination date'. What i want to do is run a query each month that will display all the contracts whose anniversary is in the month I am viewing.

The date format i am using is the medium date.

Thanks

Craig

 

[Daxton A.]

HI

Try using this
Between[Enter Start Date]and[Enter End Date]

This will let you specify the range to use.

 

[Jon K]

Try these settings in two columns in the query grid:-

Field: Month([Commencement Date])
Show: uncheck
Criteria: Month(Date())


Field: Termination Date
Table: [TableName]
Show: uncheck
Criteria: Is Null Or >Date()

 

[raskew]

Suspect I may be missing something here, but it would seem that an anniversary is nothing more than a birthday. If this is the case, here's a way you could find birthdays occurring in the current month, based on the Employees table in Northwind. Shouldn't be difficult to adapt this strategy to your scenario.

SELECT Employees.LastName, Employees.FirstName, Employees.BirthDate, Month([BirthDate]) AS ThisMonth
FROM Employees
WHERE (((Month([BirthDate]))=Month(Date())));

 

[brag89]

Anniversary Date

Many Thanks to you all that code worked perfectly.

Craig