+ Post New Thread
Results 1 to 3 of 3
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 ...
  1. #1
    Jamo's Avatar
    Join Date
    Jan 2009
    Posts
    1,349
    Thank Post
    66
    Thanked 175 Times in 147 Posts
    Rep Power
    60

    Access Queries

    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

  2. #2

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,514
    Thank Post
    1,320
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    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 ?

  3. #3
    Jamo's Avatar
    Join Date
    Jan 2009
    Posts
    1,349
    Thank Post
    66
    Thanked 175 Times in 147 Posts
    Rep Power
    60
    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
    Attached Files Attached Files

SHARE:
+ Post New Thread

Similar Threads

  1. HP ProLiant queries
    By dgsmith in forum Hardware
    Replies: 8
    Last Post: 8th April 2008, 10:37 AM
  2. Joomla Queries
    By bensewell in forum Web Development
    Replies: 2
    Last Post: 20th July 2007, 09:32 AM
  3. LimitLogin Queries
    By Gatt in forum Windows
    Replies: 11
    Last Post: 29th January 2007, 12:46 PM
  4. One||Zero queries
    By Gatt in forum Windows
    Replies: 18
    Last Post: 23rd May 2006, 02:23 PM
  5. ISA Queries...
    By Gatt in forum Windows
    Replies: 14
    Last Post: 11th May 2006, 06:42 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •