Hi All,

Our database will soon have several thousand records.
I need to create a daily activity report that only lists what happened today.
I don't know VB at all - so, with that in mind, how can I do this?

Thanks very much,
Chuck

Chuck:

You're lucky. You don't need VB for this at all.

Reports are based on tables or queries. In this case you need a
query.

Your records have a date field in them, probably more than one.
Pick the one you need.

In the criteria line of the query, in the date column that you picked
put:
Between #06/27/05# and #07/03/05#

or any range you choose.

Now the report based on the query will give you only records in that
range.
You need to fix it every week.

It can be set to work automatically, if you run it every Monday or
every Friday.

Try what I just send. If you want to do it automatically then send me
an e-mail and I'll tell you the secret.

Good luck
Ira Solomon


On Mon, 27 Jun 2005 13:13:42 GMT, "Chuck Insight"
<j.gillham (AT) insightbb (DOT) com> wrote: