storage inventory report

[Tonnie]

i need to make a report like this.

Date                in          out         store
1 jan               100         50           50
2 jan                60           70           30

etc.....

in = a db field
out = a db field
looking for a query fore the store 

[MFGF]

Hi,

How is the store value derived?  It's not clear from the example you posted how this is calculated...

MF.

[Tonnie]

Store needs to be calculated.

[MFGF]

Yes, but how?  What are the rules for calculating it?

[Tonnie]

There is no role, it's a count of goods in store. (number)

[MFGF]

Hi,

I think we have a failure to communicate here! :)

If your database is not storing the count of goods in store, what formula can you use to calculate this count based on other values you do have?

For example, is it the OUT value subtracted from the IN value for each row?  Your example above seems to indicate otherwise.

MF.