Current Sum

[Guest]

This query is regarding database related to a manufacturing process. The
processing machine generates continuously 2 small dabases for Input and
Output. The first - Input - database has Date, Time - of Input -, machine
number & Weight (of row material placed in the machine). The Second database
is for Output and has Date, Time - of output - Finished prduct number and
the count. One output record is generated for every single piece produced.
Therfore the count field is always 1.

Now, I need to know through query as to how much weight of raw material
(Total of weight) is used to produced certain number of units (Total of
Counts), for a particular machine at the time of running the query. (There
are 6 different machines and machine numbers are in input database.)

The expected out put would be like : Today's Data, Current Time, Machne 1,
100 Lbs, 80 Units. Second record will be same for Machine 2, Third record for
machine 3 and so on.

I can generate "report" to get this details but can not bring the totals by
machine by running a query.

Can some one out there help me?

Thanks in advance.

Kamal

 

[Guest]

This query is regarding database related to a manufacturing process. The
processing machine generates continuously 2 small dabases for Input and
Output. The first - Input - database has Date, Time - of Input -, machine
number & Weight (of row material placed in the machine). The Second database
is for Output and has Date, Time - of output - Finished prduct number and
the count. One output record is generated for every single piece produced.
Therfore the count field is always 1.

Are these two *DATABASES* - .mdb or .mde files, containers for multiple
tables, forms, reports? Or new tables? Creating a new database for every
record would seem to be extraordinarily inefficient!

Now, I need to know through query as to how much weight of raw material
(Total of weight) is used to produced certain number of units (Total of
Counts), for a particular machine at the time of running the query. (There
are 6 different machines and machine numbers are in input database.)

The expected out put would be like : Today's Data, Current Time, Machne 1,
100 Lbs, 80 Units. Second record will be same for Machine 2, Third record for
machine 3 and so on.

If you have a separate .mdb file for each record, this will be very
difficult. I guess I'm not understanding your system architecture! Normally
all of this information would be multiple records in a single table; if
you're trying to "union" multiple (how many? dozens? thousands?) of different
Database files, it's going to be complex.

 

[Guest]

Are these two *DATABASES* - .mdb or .mde files, containers for multiple
tables, forms, reports? Or new tables? Creating a new database for every
record would seem to be extraordinarily inefficient!


If you have a separate .mdb file for each record, this will be very
difficult. I guess I'm not understanding your system architecture! Normally
all of this information would be multiple records in a single table; if
you're trying to "union" multiple (how many? dozens? thousands?) of different
Database files, it's going to be complex.

John,

Thanks for taking time to read my L....ong query and goingthrough the details.

Now, Let me give you answers to all your questions.

Both databases are independent - .mdb files.(Two .mdb files with many
records) The records are generated in the respective files - as additional
line items. the finished products are single units and there for sum of count
gives total units produced.

I am sorry for the delayed reply.

Thanks again,

Kamal