Office Software Thread, Access Queries in Technical; I have created a database for cartridge stock at my school, (its a hot topic here at the moment with ...
13th March 2009, 08:45 AM #1
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
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
IDG Tech News
13th March 2009, 09:27 AM #2
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 ?
13th March 2009, 09:49 AM #3
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
By dgsmith in forum Hardware
Last Post: 8th April 2008, 10:37 AM
By bensewell in forum Web Development
Last Post: 20th July 2007, 09:32 AM
Last Post: 29th January 2007, 12:46 PM
Last Post: 23rd May 2006, 02:23 PM
Last Post: 11th May 2006, 06:42 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread