calculation help

[linger]

hi

is this C++ logic possible in access and if so, how do i implement it without having to code in VB (i haven't figured out how to code in VB and assimilate it into the database yet)

int test,test1,test2;

if(test!=Null & test1!=Null)
test2=test+test1;

else if(test=Null &test1!=Null)
test2=test1;

else if(test1=Null & test!=Null)
test2=test;

 

[Ziggy]

I don't know what the ! (exclamation) means in C++ but the syntax below should work



Private Sub Test()



Dim Test As Integer
Dim test1 As Integer
Dim test2 As Integer


If Test = "" And test1 = "" Then

test2 = Test + test1

ElseIf test1 = "" And Test = "" Then

test2 = test1

ElseIf test1 = "" And Test = "" Then

test2 = Test

End If

End Sub




Ziggy

 

[linger]

!= in C++ means not equal to.

uhhmm...so do I just copy and paste this into the macro or do i have to use a VB editor?

thanks

 

[Ziggy]

you would paste it into the vb editor, but correct the code where you have the ! exclamation. In VB/sql it is:

<> not equal to
>= greater than or equal to
<= less than or equal to
< less than
> greater than

Dim declares the variable, which in my example is available only to the procedure. to use the variable out side and retain the value declare the procedure as public.

You would want the code to be triggered by an event.




You can also use nested If statement in a query expression (IIF in Access)


iif(test<>Null & test1<>Null,test2=test+test1,iif(test=Null &test1<>Null,
test2=test1,iif(test1=Null & test<>Null,test2=test)))


I didn't test it but it should look something like that.

Ziggy