Search results

This was really helped me a lot... I made best db for my work. Hijama Islamia Cupping Therapy

Its great sir... many thanks for your efforts.... Please just a one thing I want to add sum of FinalValue1, FinalValue2 and FinalValue3 using same function. Thanks again

This attachment/db is looks fine... Thanks Sir... I working I think....

Sarsahi = 9 Marla = 20 Kanal = Any Digit (No limte) if we use the above mentioned Values then the answer will be like this. Kanal = 1 Marla = 1 Sarsahi = 0 These are the Land measurement units used in our area. For Example I need to add the values. Kanal Marla Sarsahi 20 18 8 23 13...

Yes you are right sir... I am unable to convey my question properly... I am trying to ask my question in better way... Thanks.

Hi sir... Need help here... I need function in ms access is below... This formula used here in our area for land measurements. K = Any number no limite for K M= 20 (20 M is equal to 1 K) S= 9 (9 S is equal to 1 M) K, M and S If S is greater than and equal to 9 then 1 add up in M For example...

Sir Many thinks for you help its work now but I have some other issues if you can solve please... When pvVal3 increase from 9 then it should plus on in pvVal2 like below pvVal3=10 and pvVal2=12 it should be like pvVal3=1 and pvVal2=13 same case for pvVal2 if should be (1) add up in pvVal1...

Hi Mr. arnelgp... Please reply for my question...

here is my email sir if it is possible to send me the db file with with module and query... It will be very great for me... mwaleedgul@yahoo.com

Data tyoe of these values are numbers and 2nd i defined a general module sir... As I am not very much familiar with ms access... So if it is possible to send me the db file? I will be grateful to you... Thanks for reply sir...

Yes I did the same

Unable to upload the pics....

Sir facing the same error... Please see the pics below Please help...

I am facing an error. Using MS Access 2013 Module Code: Public Function CalcVal(pvVal1, pvVal2, pvVal3) Select Case True Case pvVal3 >= 9 'add up in Value_2 and the Value_3 should be <9 If (pvVal2 + pvVal3) < 9 Then CalcVal = pvVal2 + pvVal3 Else...

Is it possible to add module and call it in a query?

QUOTIENT and MOD are excel functions are used to add the leftover values in the next selected cells i.e. cell B3 when exceed from the 20 it will add up to A3... I don't know how could I explain ... :-(

Thanks for your reply sir.... Here is my Question... 1st Row: Value_1 = 30, Value_2 = 12, Value_3 = 6 2nd Row: Value_1 = 15, Value_2 = 11, Value_3 = 3 According to simple calculation the Answer is Value_1 = 45, Value_2 = 23, Value_3 = 9 But the Ans should be like this.... (As...

Hi Everyone. Can anyone please help me? I have MS Access Database 2013 (ver) Tbl Fields Field_1 Field_2 Field_3 I want to calculate these fields like Field_3/9 then the answer Add/plus in Field_2 (Field_3 should be less then 9 always) Field_2/20 then the answer add/plus in Field_1...

Hi, My name is Muhammad Waleed. I am new user here...