Calculate 'As of' a certain date function

G

gladys

I need an expression for a query or report that will give me inventory counts
as of a certain date. For example, at the end of the month, I need to run a
report that tells me exactly how much inventory i have AS OF THAT DAY.
Should i run the report again in the middle of the month, then i expect the
inventory counts AS OF THAT DAY.

Any help is truly appreciated.

Thanks, Gladys
 
R

Robert_DubYa

Are you looking for query criteria that will give you todays date? If so
just use the following in your query criteria:

date()
 
A

Al Camp

Gladys,
I would imagine that <=Date() would be the criteria to filter for
"as of".

Or, a criteria of <=[Enter As Of Date] would prompt the user for a
Date. This would allow you more leeway... like running the report on the
11th of a month... but using the last day of the previous month as the As
Of.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Top