update specific record from excel

[kamils48]

Hi Guy,

First of all, thank for your help in advance

I'm tryining to find best solution for my small "kanban apliccation" on shopfloor

On PC's I have excel form which adding (INSERT function)data to one access database.DB looks like:

ID Stockcode Qt Date
1. Apple 5 2015-01-18 22:35:01
2. Orange 3 2015-01-18 22:36:03
3. Apple 2 2015-01-18 22:37:34
4. Orange 6 2015-01-18 22:39:56
5. Apple 7 2015-01-18 22:41:59

Every row means stockcode and last quantity.
How to rebuild function in excel or make a quere or use access vba to have just one stockcode with LAST qt?
Qt should be updated somehow based on specific stockcode

I will be really appreciate for youe help

[ssanfu]

Don't know if you are still working on..... there is really not enough info to make anything other than general suggestions.

Why are you using Excel and Access?

How to rebuild function in excel or make a quere or use access vba to have just one stockcode with LAST qt?

In Access, use a totals query.

Qt should be updated somehow based on specific stockcode

Shouldn't store calculated amounts because they can be calculated at any time. If you must store the result, where do you want to store the value - Excel or Access?