Access Inconsistencies

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When summing a date range, the last date data is occasionally not included.
I re-enter the same date, and then the data gets included. Not a consistent
problem...but a persistent, intermittent one. Any ideas? I'm using Access
97.
 
WordEZ said:
When summing a date range, the last date data is occasionally not
included. I re-enter the same date, and then the data gets included.
Not a consistent problem...but a persistent, intermittent one. Any
ideas? I'm using Access
97.
Click to expand...

When you filter on a date range and only enter dates you are actually filtering
on the date range that spans from midnight of the first date to midnight of the
second date. If your table data actually contains times other than midnight
then any records on the date at the end of the range that are past midnight are
not included.

That is the only reason I have seen for the end date value to be excluded, but
that behavior would not be intermittent.
 
When summing a date range, the last date data is occasionally not included.
I re-enter the same date, and then the data gets included. Not a consistent
problem...but a persistent, intermittent one. Any ideas? I'm using Access
97.
Click to expand...

In addition to what Rick has written, it may well be that you have
entered a record on your form and then printed the report before you
have actually saved the new record.
Records are not saved until you close the form, move to another
record, or explicitly save it. This would cause the exact problem you
stated.

In your code that opens the report, try:

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "ReportName", etc....
 
Back
Top