Search results

Hey. I have the same problem. Could you paste the solution here. Thanks, Joe

Guys I need some help with sumifs in access. HEre are my tables: TAble1 = Material and Quantity available ItemCode Qty A 124 B 45 Table2: Product and Priority Prod Priority Prod1 1 Prod2 3 Prod3 2 Prod4 4 Table3: This is the master table which should tell me if for the product I have...

Guys, can someone help me with this code. Still struggling with the same.

I guess im too much of a newbie to figure it out from that, though I guess the link is fine. Somebody help if possible else i guess ill figure it out eventually.. Thanks! Regards, Joe

Hey Guys, Am a total newbie, so this one should be real easy to solve for you folks. Have a table/query result Sr.NO Name Amt.Tot Amt.Needed Date 1 Mark 100 24 1/1/12 2 Mark 100 80 1/5/12 3 Tom 150 12 4/5/12 4 Tom 150 45 6/5/12 5 Joe 50 23 3/3/13 Need to add a field which is Amount.LEft so...

Have an additional question. Suppose I have an additional field - say date Is it possible to find out the amount left for each person on each date? Regards, Joe

I guess i made a mistake while filling it out.. Works like a charm! Thanks, Joe

Ok, it worked, thanks a million!!

Hey folks, this is joe from Mumbai india, total newbie to access, hardly a programmer, though have fairly expert excel skills. Technically im into project management, but im sure there is atechie hidden in me somewhere. Regards, Joe

Hey Guys, Am a total newbie, so this one should be real easy to solve for you folks. Have a table/query result Sr.NO Name Amt.Tot Amt.Needed 1 Mark 100 24 2 Mark 100 80 3 Tom 150 12 4 Tom 150 45 5 Joe 50 23 Need to add a field which is Amount.LEft so that the table looks like this Sr.NO...