Converting

[Guest]

I have a product database, I receive items by POUNDS and then it gets converted into BAGS. Usually 50 lb bags but I need to convert the BUlk into Bag inventory? Any help.

 

[Ken Snell]

Your description doesn't give us enough information to provide suggestions.
What is BULK? Where does it come from? What is converting POUNDS to BAGS?
Where are converted values to be stored? What will you do with the
information once you've converted it? Is it necessary to convert the data --
or can you just "convert" it via a query when you want to display it on a
form or on a report?

--
Ken Snell
<MS ACCESS MVP>

I have a product database, I receive items by POUNDS and then it gets

converted into BAGS. Usually 50 lb bags but I need to convert the BUlk into
Bag inventory? Any help.

 

[Guest]

I quess it would be something like receving product in by the gross but keeping it in inventory by eaches,

 

[Ken Snell]

? Are you saying that you receive data in units of pounds but want to store
it in units of bags?


--
Ken Snell
<MS ACCESS MVP>

I quess it would be something like receving product in by the gross but

keeping it in inventory by eaches,

 

[Guest]

Yes, I receive the units in pounds and then (after they process or treat the pounds) i store them by bags.

 

[Larry Linson]

I quess it would be something like receving product in by the gross but

keeping it in inventory by eaches,

Are you storing a record for each bag, or are you recording the receipt of
bags (calculated from pounds) in one record, and removal of bags in other
transaction records? You see, how you have structured your data storage is
going to determine how you need to go about this.

There's good infomation on inventory applications at MVP Allen Browne's
site, http://allenbrowne.com.

Larry Linson
Microsoft Access MVP

 

[Mike Painter]

I have a product database, I receive items by POUNDS and then it gets

converted into BAGS. Usually 50 lb bags but I need to convert the BUlk into
Bag inventory? Any help.

This sounds like an agricultural item and can be a real pain, especially if
you get in pounds which must go to boxes which contain a certain number of
items based on size or shape or color and Arggggggh.

GET WHAT THEY WANT IN WRITING. Have a copy of what they wrote down when they
tell you that's not what they meant.

It is a horrible problem because all you can really do is divide what came
in by 50 and get an estimated number of bags. Truncate it and hope the
leftover stays in the bins and that they don't do any additional culling,
that nothing spills and that bags don't break. If it goes directly from a
bin to a bag that should work.
Sometimes the old ways work best.

 

[Ken Snell]

As noted elsethread, your choice is to do a mathematical calculation on the
pounds values to convert them to bags (divide them by 50). This can be done
by an update query if you use the table into which the data are imported, or
can be done by an append query that copies data from the imported table to
the permanent table. Or, you can just go ahead and store the units as pounds
and then use a calculated field in queries whenever you want to display the
quantities in bags when you've stored them in pounds.

--
Ken Snell
<MS ACCESS MVP>

Yes, I receive the units in pounds and then (after they process or treat

the pounds) i store them by bags.

 

[Guest]

Thanks