running a query to inform me before one month

  • Thread starter Thread starter Cheanir H via AccessMonster.com
  • Start date Start date
C

Cheanir H via AccessMonster.com

hello

hi i have an MSaccess about a state agent and what i can not workout is that
i want to run a query that informs me one month a head of the contract end
date so i can basically inform the tenants that their contract is due to
finish!

i have contract start date and contract end date set in date/time
i can not find an expression that matchs what explained above

anybody has any sulotion please i realy need to get this done

thanks
 
try

DateAdd("d", -30, [ContractEndDate])

or

DateAdd("m", -1, [ContractEndDate])

in either case, substitute the correct name of your "contract end date"
field.

hth
 
tina said:
try

DateAdd("d", -30, [ContractEndDate])

or

DateAdd("m", -1, [ContractEndDate])

in either case, substitute the correct name of your "contract end date"
field.

hth
Click to expand...

hi

thanks for your message

but it is still not working. The sulotion you proposed above shows all the
contract End date there is nothing in particular that is left out or not
selected, at the same time there are contract end dates that are far from now
by 8 months therefore them dates should not be shown for the purpose. what i
need the query percisely to select are the contract end date that are due in
the next 30 days not the ones who are may be 3 or 5 months away.

thanks for your time i am ever so greatefull if you know more about this
please
 
Cheanir H via AccessMonster.com said:
hello

hi i have an MSaccess about a state agent and what i can not workout is that
i want to run a query that informs me one month a head of the contract end
date so i can basically inform the tenants that their contract is due to
finish!

i have contract start date and contract end date set in date/time
i can not find an expression that matchs what explained above

anybody has any sulotion please i realy need to get this done

thanks
Click to expand...

If you create a query and a WHERE clause similar to this one:

WHERE DateDiff("d",Date(),[ContractEndDate])< 31) AND [ContractEndDate] >
Date()

it will select all of the ContractEndDate's after today and during the next
30 days

HTH,
Randy
 
Back
Top