[ms office - 2003] Access Queries

[Jamo]

I have created a database for cartridge stock at my school, (its a hot topic here at the moment with a lot of money being spent on printing) but I am having a few issues with Access queries.

 

I have currently got a query which shows the cartridges in stock and how many eg

 

Cartridge Stock

--------- ------

339 7

344 5

 

Etc

 

I also have a table which shows the required cartridges (some of which wont show up on the stock list becuase the query only counts items in stock). Is there a way of combining the tables to show 0 stock on some cartridges without using VBA?

 

Apologies if its not clear :s

[RabbieBurns]

can you upload the database for me to take a look at? I find creating queries a lot easier if I can see the table and fields etc. And yes, if you could clear up what you mean - you want it to also list all the printers with 0 cartridges in stock ?

[Jamo]

yeah sure, its a bit of a mess atm to be honest so disregard the slightly haphazard VBA coding!!

 

The queries in question were the "CartridgesRequired" one which obviously shows the cartridges the printers need and "StockLevels" which show the levels of cartridges in stock.

 

PM me if your confused about my weird logic

Printer.zip