Locating Empty Bins


(system) #1
The full list of Bins is in the WhseBin table. You need to compare
it to the PartBin table and list all Bins that exist in WhseBin that
don't exist in PartBin. There may be ways to do this in Crystal or
Report builder, but I'm a fan of Access. Create a make table query
for both tables in Access and include the relevant fields. Next
create a query using the Find Unmatched Query Wizard. It will tell
you which fields exist in one table that don't have a match in the
other.

HTH,

Brian Stenglein
Clow Stamping Company

--- In vantage@yahoogroups.com, Jerry Hardy <j2hardy@y...> wrote:
> How can we find/print a list of all empty bins?
>
>
> ---------------------------------
> Yahoo! Messenger
> Show us what our next emoticon should look like. Join the fun.
>
> [Non-text portions of this message have been removed]

(system) #2
How can we find/print a list of all empty bins?


---------------------------------
Yahoo! Messenger
Show us what our next emoticon should look like. Join the fun.

[Non-text portions of this message have been removed]

(system) #3
> How can we find/print a list of all empty bins?


The short answer is: Not Easily.

The PartBin table only maintains records for bins that have items in them.
No inventory, no record in the table.


============================================
Malcolm Spann
MIS
Malmberg Engineering
(925) 606-6500 x19
Malcolm@...
============================================