Results 1 to 9 of 9
  1. #1
    Mina Garas is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    33

    Store database problem

    Hi everybody

    i have a store database

    1- i have open stock query that contains a list of item Codes,item description,quantity and price and this list is limited
    for example : open stock query for February (current month) has a 100 item code with previous details and that mean we begin February with 100 item

    2- i have in query and this query contains all purchased items for current month. this query contains the same details of open stock query

    3- i have sales query that contains all sold items for current month (February).

    4- i have Stock Query to display the stock for current month and this stock list will used as an open stock list for march
    and i calculate the stock by : Stock = (open stock + in ) - sales

    i joined all queries using codes and date
    my problem is when i sort my stock query fields as the follow :



    date , code , des , OpenStock , In , sales , Stock

    i joined code fields depend on open stock ItemCode

    my problem is if i add a new itemcode in InQuery this itemcode does not display in the stock query because that new code doesn't exist from the beginning in the open stock query (100 + 1) . how can i add the new item code in InQuery and display in Stock Query
    please help

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Post a jpg of your tables and relationships, and/or post a copy of your database. (zip format preferred)

  3. #3
    Mina Garas is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    33

  4. #4
    RDT0086 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    6
    You can attach it to this post. Either by using the insert image button above or going to go advanced.
    Click image for larger version. 

Name:	pic.jpg 
Views:	12 
Size:	51.4 KB 
ID:	23655
    Attached Files Attached Files

  5. #5
    Mina Garas is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    33

  6. #6
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    A word of warning: the Access Gnomes sometimes get really persnickety when object names begin with a number.

    See this thread http://www.vbforums.com/showthread.p...g-with-numbers

    And http://www.vbforums.com/showthread.p...-tables-fields



    "Size", "Type" and "Date" are reserved words and shouldn't be used as object names (field names).

    Shouldn't use spaces, punctuation or special characters (underscore is the exception) in object names

  7. #7
    Mina Garas is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    33
    links doesn't work

  8. #8
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    When you have multiple tables with same structure---could be a design problem.

    Please tell us why these tables exist. What makes them different from one another?

  9. #9
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    links doesn't work
    Links are fixed.....

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Fictional store Database design
    By RJConroy86 in forum Database Design
    Replies: 1
    Last Post: 01-26-2015, 02:43 PM
  2. Proper way to store attachments in a database?
    By alexandervj in forum Access
    Replies: 3
    Last Post: 04-29-2014, 02:52 PM
  3. Form design for tool store database
    By V760838 in forum Database Design
    Replies: 1
    Last Post: 02-11-2012, 08:09 AM
  4. Access 2007 Store Management Database
    By dnbbrain in forum Access
    Replies: 9
    Last Post: 10-19-2011, 02:29 PM
  5. Pizza store database help!
    By zagorette in forum Database Design
    Replies: 2
    Last Post: 06-30-2009, 10:47 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums