Production Report

Good morning,

I am trying to create a report for one of my workcenters that shows quantity
produced per machine, per shift, per month. The items we produce can be
either rec'd to stock, shipped on an order, or act as a sub-assembly to
another workcenter. I am using the JOBPROD table, however I do not know how
to specify the previous month as the filter. On other reports I have used
(IFF fiscalperiod =10...)however this does not verify, unrecognized command.
Does anyone have a report like this? If not, can I get some help?

Todd Hofert

Todd Hofert
Spartan Graphics, Inc.
(616) 887-8243

[Non-text portions of this message have been removed]