Re: How to Find the Date of Last Change in Inventory

Tech-Archive recommends: Fix windows errors by optimizing your registry

If theses are the lines you are talking about, I don't know where they came
from in relation to the code I sent.

If your report has visibility to the query, then the query is the way to go.
If you could post the code as you modifided it, the lines that turn red, and
the error message the lines are returning, maybe we can work through it.

> ("SLOBInv2StyColDatUntqry")
>
> (dbOpenSnapsh?ot, dbReadOnly)
>


"doyle60@xxxxxxx" wrote:

> So I changed that one spill over line and it seems to work. The other
> lines I mentioned that are red are still red. When I run the code, it
> gives me a compile error on "qdf =" in the first line.
>
> <You could use a query, but getting it from the query to the report
> would be
> an issue.>
>
> Really? I don't know why myself. Once I have a query, I'm usually
> home free.
>
> < Perhaps a temporary table that the report could use would be the
> best solution. >
>
> I have no problem with a table that holds the following data:
>
> Style, Color, LastSLOBDate, SLOBDays.
>
> Where the LastSLOBDate would be the most recent date for the
> Style/Color, and where SLOBDays are the value we are looking for here.
>
>
> I technically don't need LastSLOBDate here; I can get it later (and
> filter out those style/colors that do not have the latest date---that
> is, the inventory is null, sold out.
>
> By the way, SLOB stand for Slow Moving and Obsolete (Inventory).
>
> What should I do next? I'm sort of stuck here.
>
> Matt
>
>
.

Relevant Pages

  • Re: Calculating an inventory balance at a "point in time"
    ... This query should roll up all previous transactions into a single row. ... create a report based on this query ordered by PartNumber and TransDate. ... can create a group header on PartNumber to display the beginning balance. ... the new amount of inventory and the # of days that the inventory ...
    (microsoft.public.access.reports)
  • Multiple criteria in a query
    ... The report is designed to show expenses for vehicles in my car pool. ... I've got the first criteria set for a specific date range (which is entered ... The criteria for this in the query is ... the user the option also to sort by vehicle inventory number. ...
    (microsoft.public.access.queries)
  • Re: Duplicate Records in a SW Inventary Query
    ... operating system details. ... I'm working to create a very simle SW inventary Query, that report will ... mcahines in a SW inventory. ...
    (microsoft.public.sms.inventory)
  • Re: Distinct Record Counts
    ... The table is Inventory Transactions. ... The equipment sold totals work fine, ... when I place this final query in my Source ... How can I get this number to show in the report? ...
    (microsoft.public.access.queries)
  • Report (or Query) being naughty
    ... I have a report based on a query from tables Products, Categories, and ... Inventory Transactions that is supposed to bring up all items in a certain ... I look in the query and its all there, ... Products.CategoryID) INNER JOIN ON ...
    (microsoft.public.access.reports)