HELP....please....

[Ulrik Martinsson]

Hi out there...
Im in deep trouble...*lol*
--------------
Fields :
Lager = Total.
Tilgang = +
Nordbar = -
--------------

How can i get access to calculate this :

When i typing in "tilgang" i need to + the number with "total" and stay in
the total field.

When i typing in "Nordbar" i need to - the number in "norbar" with the
"total" how can i do this...

Im a super NooB to access...
It's kind a iventory control...

 

[Kevin Sprinkel]

Ulrik,

I'm not sure what you're trying to do. For example, if
you type in tilgang, how do you *remain* in the Total
field?

Do you want a Total for each set of Tilgang and Nordbar
values, or an entire total for the recordset?

Please provide some generic background on what you're
trying to do.

Kevin Sprinkel

 

[Ulrik Martinsson]

Ok i'll give a shot...
Im working on a ferry, and the people have ask me to make a inventory
database...
I'm a super user to fix computers, but making a database in access im a
total Noob...lol

The are many items in the database.
And evry day there is a lot of "out and in"

The total shall be what's on storage.

When im using "Nordbar"=Out" The number im typing in that field should be -
from the total.. and clear the field for new input.

When im using "Tilgang"=In" The number im typing in that field should be
added to the total, and clear the field for new input...

I hope you understanding this...

Ulrik Martinsson

 

[Kevin Sprinkel]

Ulrik,

Inventory management is a tricky thing, and one which I've
not tackled. I bet though, that some of our MVP's have
and can assist you.

I suggest you repost with "Inventory Control" in the
subject heading.

Sorry I couldn't help.

Kevin Sprinkel

 

[Ulrik Martinsson]

That's Okay...

But thanks anyway...

Ulrik,

Inventory management is a tricky thing, and one which I've
not tackled. I bet though, that some of our MVP's have
and can assist you.

I suggest you repost with "Inventory Control" in the
subject heading.

Sorry I couldn't help.

Kevin Sprinkel