Re: Math in Table?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 04/14/04 

Date: Tue, 13 Apr 2004 22:15:22 -0500

Don't create a separate table for each production line. Create one table
with a field for Line. You don't do the math in tables. It is quite easy to
display totals or calculations in queries where you create calculated
columns.

There are lots of methods to filter results/records returned in a query,
report, or form. 

-- 
Duane Hookom
MS Access MVP
"Keith" <kceule@americaningredients.com> wrote in message
news:1c33601c421ca$d3f42600$a301280a@phx.gbl...
> I'm in the middle of converting what is essentially an
> Excel database into an Access db.  I work in a production
> facility, and the supervisors need to be able to access
> data easily, as they have limited computer skills.
> I have had them enter data in a basic spreadsheet, and
> then I created macros such that they only had to click a
> button and the data was automatically pulled from the
> sheet and dumped into a separate tab to be stored.
>
> We have 3 shifts that need to be entered daily.  We have
> 12 production lines that need to be tracked
> individually.  The key components of each line are:
> product code, units scheduled, units packed, unit weight,
> scheduled pounds, pounds packed, labor hours, pounds per
> labor hour, and % acheived.
>
> I think I am going to create a separate table for each
> production line... does that sound like a good idea?
> I would like for the tables to automatically do the
> calculations for the fields "scheduled pounds" (units
> scheduled*unit weight), "pounds per labor hour" (pounds
> packed/labor hours), etc.  Can this be done in a table,
> or do I need for it to be done in a query or report
> (which would be better?).  Bottom line, I don't want
> those entering the data to have to type in these simple
> values, and I would like something that I can print out
> with all of this info.
> I'm new to Access.  We will need reports for each PC by
> day... how do I set up a query or report to select the
> correct three rows (one for each shift) automatically?
>
> Thank you for taking the time to help me.  I appreciate
> it!

Relevant Pages

  • Math in Table?
    ... 12 production lines that need to be tracked ... scheduled pounds, pounds packed, labor hours, pounds per ... labor hour, and % acheived. ... or do I need for it to be done in a query or report ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Liar Liar Pants On Fire Dept: Moller
    ... I think it's kinda funny that the best you can find in the report ... supports my position (that no one could verify that Iraq had actually ... production facilities were destroyed. ...
    (alt.politics)
  • Current vs. Last years USA price comparison
    ... sustained in the beef sector, according to the latest forecast report ... The gap between domestic beef production and consumption is greater ... January imports of processed beef were 35 million pounds more than ... expectations for little production growth and higher exports. ...
    (uk.business.agriculture)
  • Re: Help with table structure for manufacturing production counts
    ... I currently receive a weekly report from the plant managers that gives Model numbers, quantity built, and how many have each various options (ie: color, glass doors, casters, compressor hp, voltage etc). ... The buyers in the purchasing department use the data from this report to help them keep track of inventory of their purchased components and predict what they need to buy in the upcoming weeks. ... I began to set up a table to use to house the data that comes from the weekly production reports ...
    (microsoft.public.access.gettingstarted)
  • =?windows-1252?Q?CHAPTER_XXII_THE_PRODUCTION_AND_CONSUMPTION_OF_COFFE?= =?windows-1252?Q?E__
    ... THE PRODUCTION AND CONSUMPTION OF COFFEE ... in the United States, past and present—Reviewing the 1921 trade in the ... pounds the annual world output amounts to about two and a quarter ...
    (alt.coffee)