Four criteria to create ALL my reports!

  • Thread starter Thread starter Carrie
  • Start date Start date
C

Carrie

I have boiled down the entire production inventory system
to four key fields:

EmployeeName
Station (as in assembly line station, for example)
Date
Output (an integer)

I currently have a lookup table for EmpName and Station.
Date and Output are recorded on one form where employee
and station are looked up.

All my reports are based on either:
an employee at a station and his output
a station and its output...

....and each of those by day, week, or month or a set of
days, weeks, or months.

I would love to create just one report where the user
simply selects the name (optional), stage, and date range
from combo boxes and then receives the results... for
example:

Report for November, 2003
Name Station Output
Anupa Lathe 9600
Kati Polishing 10500
Raj Lathe 8000
Raj Mill 5000

OR-- Report for November, 2003
Lathe: 17600
Mill: 5000
Polishing: 10500

Or Report for Lathe, 2003
January: x
Feb: y
Mar: z
etc.

Can I do this?
Much thanks in advance.
 
Carrie said:
Cool -- thanks, it's working now.
Click to expand...

That's good to hear.

Is there a syntax guide somewhere that I could access?
Click to expand...

Well, there's the Help files, but the syntax rules are
scattered and more implicit in the object tree or SQL
descriptions than explicitly layed out in a nice, neat
concise manner. Kind of makes you feel like a small child
trying to learn English before you're able to read a book on
grammatical constructs ;-)
 
Back
Top