DateDiff() and AVG function questions

[intl04]

I'm trying to set up a query that will include a new field ('Days
until completion') whose value is derived from the DateDiff function.
I think I have the syntax correct but am not sure.

Days until completion: DateDiff("d",[TODAY],[DeadlineDate])

is TODAY the appropriate syntax for today's date? Could the
function/expression even be set up that way, or do I need to do
something else to get 'days until completion'? (My Access manuals do
not mention a TODAY function and Access help doesn't have anything
about DateDiff anyway.)

Another question: with the AVG function, is it possible to first
remove outlying numbers (the lowest and/or highest numbers in the
range)? Is there some way to remove outliers or does this have to be
done manually?

My understanding is that there will be a database to track project
development by phases (which would be a series of date ranges in a
query, I guess); then I'll be getting an average of test scores for
each phase.

[Fredg]

Today is not an Access function.
Use Date() if there is no time of day element needed.
If you need the time of day also, then use Now().

Days until completion: DateDiff("d",[DeadlineDate],Date())

Don't use Access help for references to a function.
Use VBA help instead.
Open any code window and click on Help there.
Try it by typing DateDiff in Access Help, then open any code window and
type DateDiff there. It show up in the VBA Help.

For information about Avg() look up DAvg() in VBA Help.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
"intl04" <in****@hotmail.com> wrote in message
news:b7**************************@posting.google.c om...

I'm trying to set up a query that will include a new field ('Days
until completion') whose value is derived from the DateDiff function.
I think I have the syntax correct but am not sure.

Days until completion: DateDiff("d",[TODAY],[DeadlineDate])

is TODAY the appropriate syntax for today's date? Could the
function/expression even be set up that way, or do I need to do
something else to get 'days until completion'? (My Access manuals do
not mention a TODAY function and Access help doesn't have anything
about DateDiff anyway.)

Another question: with the AVG function, is it possible to first
remove outlying numbers (the lowest and/or highest numbers in the
range)? Is there some way to remove outliers or does this have to be
done manually?

My understanding is that there will be a database to track project
development by phases (which would be a series of date ranges in a
query, I guess); then I'll be getting an average of test scores for
each phase.