Report or Form, need advise reference stock locations/crossmatch

[bishmedia]

I have a table of Stock Locations created by 'qryTableMerge' and the stock held in each location. e.g. JM025A, JM025B, JM025C etc etc



I need to create a 'Freespace Report' that shows locations that have no stock, but my table only shows locations with stock so i'm guessing i'll need to create a 2nd table that just has all locations and cross match both.

Not sure what is best, whether to create a report or a form or basically where to begin!!

Hope this makes sense and any advise would be great.

[pbaldy]

You would need a table with all locations, a query joining that table to your existing query, and a report based on that query.

[bishmedia]

I'm sort of on the same line of thought, I have over 19,000 locations so I need to ensure I'm looking at this correctly right from the start but I guess first would be to setup all locations in a table of its own.

[pbaldy]

Yes, if you want to be able to report on locations with no stock, there needs to be a list of all of them.

[bishmedia]

Ok so now I have a table 'tblLocationMaster' with a field of Locations 'LocationMaster' and a Stock Table 'qryTableMerge' and a field called 'Location' for current stock.

How is it best now to list just empty locations??? DLOOKUP ??

[pbaldy]

Try the unmatched query wizard.