How to Lomit a Report

[Chuck Insight]

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

[Keith]

"Chuck Insight" <j.*******@insightbb.com> wrote in message
news:uYSve.109902$nG6.86901@attbi_s22...
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?

You needn't use VBA, you could use a query with criteria on your date field
">Date()" for example. Of course, you'd need a date field to store an
"updated" or "created" date to start with but that could be populated from a
query as well.

HTH - Keith.
www.keithwilby.com

[BillCo]

The answer is in the query under the report. If there is a date field
anywhere for the date of entry then you can put in a condition like >
(date() - 1) to get just the last day. I recommend that if you dont
have a field which automatically tracks the date of entry you should
put one in.

Alternatively, if you have an autonumber field to work with, you can do
a query which specifies only the last n records:

SELECT TOP 100 autonumberField, otherfields....
from tblYourTable
ORDER BY autonumberField DESC

Hope this helps

[Bas Cost Budde]

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:

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

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html

[Tim Marshall]

Chuck Insight wrote:

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?

You don't need to know VBA for this, but you do need to know your
database structure.

Do any of the tables have a "Enter Date" or "Transaction Date" field
that is filled when a user neters a record? If so, you're in luck. If
not, you don't need to despair, it sounds like you're still at an early
enough stage to be able to incorporate this.

If you don't know how to determine the above, then you are in trouble
unless you have access to the database designer who set this up for you.

Write back and we can go from there.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Keith]

"Tim Marshall" <TI****@PurplePandaChasers.Moertherium> wrote in message
news:d9*********@coranto.ucs.mun.ca...

when a user neters a record?

Did anyone else's eyes water when they read this? ;-p

[Patrick Fisher]

My eyes watered at the thought of Lomiting something
Patrick

On Mon, 27 Jun 2005 15:32:06 +0100, "Keith"
<ke*********@baeAWAYWITHITsystems.com> wrote:

"Tim Marshall" <TI****@PurplePandaChasers.Moertherium> wrote in message
news:d9*********@coranto.ucs.mun.ca...

when a user neters a record?

Did anyone else's eyes water when they read this? ;-p

[Bas Cost Budde]

So yopu never make speling error? Or mistype anthinh?

Besides: Is 'neter' an existing verb? Or does it sound like anything to
you? I can't tell. That is, it does ring to me (the meaning being close
to bug-egg treater), but that won't tell you anything.

Keith wrote:

"Tim Marshall" <TI****@PurplePandaChasers.Moertherium> wrote in message
news:d9*********@coranto.ucs.mun.ca...

when a user neters a record?

Did anyone else's eyes water when they read this? ;-p

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html

[jimfortune]

Keith wrote:

"Tim Marshall" <TI****@PurplePandaChasers.Moertherium> wrote in message
news:d9*********@coranto.ucs.mun.ca...

when a user neters a record?

Did anyone else's eyes water when they read this? ;-p

Since twiddled characters are one of the most common spelling errors my
mind converted the word without even thinking about it. But now that
you mention it, it does have a Three Stooges-style element of comedy to
it. I prefer Trevor's more subtle style of comedy that lets you put
the punch line together in your head.

James A. Fortune

Jeff Macauley: How long does it take you to determine how good a
programmer is?
Me: How long does it take you to determine how good a pool player is?

[Tim Marshall]

Keith wrote:

"Tim Marshall" <TI****@PurplePandaChasers.Moertherium> wrote in message
news:d9*********@coranto.ucs.mun.ca...

when a user neters a record?

Did anyone else's eyes water when they read this? ;-p

Ha ha ha, just saw this now. 8)

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me