Limit report to records above "0"

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

Guest

I have a report generated from an [AttendanceRegister]. On tht report it
shows the [Date], [Employee] and [SickTime]. All of this information appears
on the report. But days where sick time is "0" show up as well. How can I get
only records that are anything above "0" only???

Thanks in advance for your help
 
Hi Roby,

Is [AttendanceRegister] the name of a table? If so, the simplest method
would be to create a query based on that table, and set the criteria for the
[SickTime] field to ">0". Save the query (with a different name than the
table name), and set the report's Record Source to the query, rather than
the table. If [AttendanceRegister] is already a query, just set the
criterion in the existing query.

HTH,

Rob
 
Roby said:
I have a report generated from an [AttendanceRegister]. On tht report it
shows the [Date], [Employee] and [SickTime]. All of this information appears
on the report. But days where sick time is "0" show up as well. How can I get
only records that are anything above "0" only???
Click to expand...


Before you worry about the report, you need to make sure
that the report's record source query contains the desired
set of records. In this case, it sounds like the query's
[SickTime] field needs to have a criteria of >0
 
Thanks everyone, that worked perfectly. Simple I never even thought of
that,lol.

Thanks agian.

Marshall Barton said:
Roby said:
I have a report generated from an [AttendanceRegister]. On tht report it
shows the [Date], [Employee] and [SickTime]. All of this information appears
on the report. But days where sick time is "0" show up as well. How can I get
only records that are anything above "0" only???
Click to expand...


Before you worry about the report, you need to make sure
that the report's record source query contains the desired
set of records. In this case, it sounds like the query's
[SickTime] field needs to have a criteria of >0
Click to expand...
 
Back
Top