Connecting Tech Pros Worldwide Help | Site Map

Stores Balance

 
LinkBack Thread Tools Search this Thread
  #1  
Old March 11th, 2008, 12:55 AM
c8tz
Guest
 
Posts: n/a
Default Stores Balance

My database is such where I have Stores at each location. Firstly how
do I initialise a store such that it shows 0.00 if there is no stock.

Then from say Store1 - This store receives stock from another store
such that its balance increases and at times, transfers stock (out) so
its balance decreases.
Similar for other stores.
I've done a query and put on a form so that it updates the balance
everytime through requery.

But this only works if there has been a transfer from and transfer to
done.

I would like it to also show if such that only a transfer from is done
or transfer to is done and not both.

Please help

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,989 network members.