How will you tell what 'happened' 'today'?
Define 'happen'. I can figure what you target by 'today' :-) you
probably want an edit date in the record. That means you have to write
that from any form that uses the table(s) you want to report.
You can use the BeforeUpdate event of the form for this. First, extend
your table with a Date field, called dateEdited
Open the form that performs the 'happen' in design view
Make sure the form is selected, not some control (click the box at the
intersection of the rulers)
View the properties (from the menu, or the contextmenu)
Select the Events tab
at BeforeUpdate, select [Event Procedure]
Click the three dot button that becomes visible
At the location in the code module, type
dateEdited = Now()
Now, you can use a query to retrieve the records modified today. Have
int(dateEdited) in a column head, and Date() in the criteria row.
Qapla'!
Chuck Insight wrote:[color=blue]
> 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[/color]
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html 
