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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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: How to Find the Date of Last Change in Inventory
    ... If your report has visibility to the query, then the query is the way to go. ... > Style, Color, LastSLOBDate, SLOBDays. ... SLOB stand for Slow Moving and Obsolete (Inventory). ...
    (microsoft.public.access.modulesdaovba)
  • Re: Need Help designing a table structure
    ... Well, I don't really know anything about ColdFusion, but you could do what ... form with fields that represent the fields from the inventory table, ... The form which is unbound can call another form ... which is bound using that query as the record source. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Show all records on a joined query with criteria
    ... > inventory items to the order. ... " created one query that has 2 tables joined showing ... SQL View from the menus, View> SQL View, and copy and past the SQL ... MyTableOneID AUTOINCREMENT PK ...
    (microsoft.public.access.queries)
  • Re: parts inventory management
    ... You might also want to look over the MS template for inventory management. ... PurchaseOrderNum ... TblPurchaseOrderDetail ... The query would include ...
    (microsoft.public.access.tablesdbdesign)
  • Re: HELP!! Jet Database Engine Error on Crosstab Query
    ... Inventory].[Connection Inventory ID]" as a valid field name or expression. ... > The crosstab query is based on another query that works fine by itself. ... History].Date, [Connection Inventory]., ...
    (microsoft.public.access.queries)