Recent content by mwaleedgul

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?