Current stock calculation by store location

[Arjun032]

I have 3 table

1. stock IN
   which contains
   ID (primary key)
   PRODUCT
   DATE
   QUANTITY
   REMARKS
   RECEIVED BY
   STORE POINT

2.Stock OUT
STOCK_OUT_ID
CUSTOMER
PRODUCT_NAME
DATE
QUANTITY
REMARKS
STORE POINT

3. Products
   Product Name
   Product Description
   Price Image
   Total Inventory
   Total Requested
   Total Available
   store location(V C)

now current stock will be calculated by

SUM(
** SELECT(**
** Stock IN[QUANTITY],**
** [PRODUCT] = [_THISROW].[Product Name])) -**

sum( SELECT(
** Stock out[QUANTITY],**
** [PRODUCT_NAME]= [_THISROW].[Product Name]))**

This is only display the number of stock

But i have to display current stock of an item by store location and current stock of a item in that location .

how this possible??