Re: Products Report Help

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

How would I translate it?

"Larry Linson" wrote:

You are going to have to determine how you handle the situation in which you
have two different units of measure. It is often the case that material is
purchased in one (larger) unit of measure, and distributed or sold in a
different (smaller) unit of measure... in that case, generally, adding to
inventory translates the larger unit to the smaller unit. I suspect you are
may have to keep track in your database of "pages" and provide for the form
into which the withdrawal information is entered to translate between reams
and pages.

Access' "psychic features" have not yet been announced, so the user is going
to have to indicate "reams" or "pages/sheets". Templates aren't expected to
always be usable for production without some modification for user-specific
instances such as this.

Larry Linson
Microsoft Office Access MVP

"Mya48" <Mya48@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:533336B5-E2D2-417B-8FC1-0F5D460A82CA@xxxxxxxxxxxxxxxx
I used the Inventory template and it's great. The database works great but
I
am having problems generating a report that will give the data I want.
These
are the fields in the products table:

ProductID
ProductName
CategoryID
Supplier
ItemNumber
Unit
QuantityPerUnit
UnitPrice
ReorderLevel
Discontinued
LeadTime
Photo

The problem I have is that when we distribute colored paper or folders to
employees, they don't always want a box of folders or a full ream of
paper.
In the QuantityPerUnit field, I have listed that there's 500 sheets per
unit
(ream) or 25 folders per unit (box). How then would I get an accurate
report
as to how much has been spent if Joe ordered two reams of paper and John
ordered 40 sheets of paper? The way the report is set up right now, it
would
show 1,040 sheets of paper has been spent. This turns out to be an out
liar
when I run a report on the most commonly used supplies because 1,040 would
show up at the top when in fact it should only be 2 reams plus 40 sheets,
but
that's where I'm stuck. I don't know how to fix the Units issue. Any
help
is appreciated.



.

Relevant Pages

  • Re: Products Report Help
    ... am having problems generating a report that will give the data I want. ... I have listed that there's 500 sheets per ... as to how much has been spent if Joe ordered two reams of paper and John ...
    (microsoft.public.access.reports)
  • Products Report Help
    ... am having problems generating a report that will give the data I want. ... I have listed that there's 500 sheets per unit ... as to how much has been spent if Joe ordered two reams of paper and John ...
    (microsoft.public.access.reports)
  • Excel worksheets embedded in Word revert to original contents after modification
    ... I translate a weekly report in Word format which ... I dutifully translate the text from Spanish into ... This only seems to affect the two embedded Excel worksheets. ... as the body of the report and standard tables, ...
    (microsoft.public.mac.office.word)
  • Military service can translate to marketable skills
    ... Military service can translate to marketable skills ... with our laws this report cannot be provided in ... Military News and Information Editor ...
    (soc.veterans)
  • Re: Simulating Post-Synthesis Model on Xilinx FPGA
    ... I thought translate and map was using the LOCed pin ... so it's a little different from FPGA synthesis. ... There were no errors in my synthesis report, translate report, ...
    (comp.arch.fpga)