Report Equation Access 2003

  • Thread starter Thread starter Denver
  • Start date Start date
D

Denver

Hello everyone,

I have this syntax in this control source
= IIf(Abs(Sum([ApprovedRL]))=(Sum([Update])),"Complete", Abs(Sum([Update])))

I want no figures to appear in the report when it is not equal to
(Sum([Update]),
would it be possible?
what syntax do I need to add to make it possible?

thanks
 
Maybe like this --
= IIf(Abs(Sum([ApprovedRL]))=Abs(Sum([Update])),"Complete",
Abs(Sum([Update])))
 
= IIf(Abs(Sum([ApprovedRL]))=(Sum([Update])),"Complete", Abs(Sum([Update])))

base from this equation I want to add syntax that when a value from my
(Sum([Update])) field is not be equal to Sum([ApprovedRL]) no figures should
be appeared in the report?

I try to work on this equation but it doesn't work

IIf(Abs(Sum([ApprovedRL]))=(Sum([Update])),"Complete", &
IIf(Abs(Sum([ApprovedRL]))<>(Sum([Update])),"",Abs(Sum([Update]))))

can you help me work on this?

thanks

Duane Hookom said:
What do you mean by "I want no figures to appear in the report"?

--
Duane Hookom
Microsoft Access MVP


Denver said:
Hello everyone,

I have this syntax in this control source
= IIf(Abs(Sum([ApprovedRL]))=(Sum([Update])),"Complete", Abs(Sum([Update])))

I want no figures to appear in the report when it is not equal to
(Sum([Update]),
would it be possible?
what syntax do I need to add to make it possible?

thanks
Click to expand...
Click to expand...
 
I guess I didn't know what you meant by "no figures". I doubt this is what
you want but it meets your specs:

=IIf(Sum([Update]) <>Sum([ApprovedRL]), "No Figures", Null)

--
Duane Hookom
Microsoft Access MVP


Denver said:
= IIf(Abs(Sum([ApprovedRL]))=(Sum([Update])),"Complete", Abs(Sum([Update])))

base from this equation I want to add syntax that when a value from my
(Sum([Update])) field is not be equal to Sum([ApprovedRL]) no figures should
be appeared in the report?

I try to work on this equation but it doesn't work

IIf(Abs(Sum([ApprovedRL]))=(Sum([Update])),"Complete", &
IIf(Abs(Sum([ApprovedRL]))<>(Sum([Update])),"",Abs(Sum([Update]))))

can you help me work on this?

thanks

Duane Hookom said:
What do you mean by "I want no figures to appear in the report"?

--
Duane Hookom
Microsoft Access MVP


Denver said:
Hello everyone,

I have this syntax in this control source
= IIf(Abs(Sum([ApprovedRL]))=(Sum([Update])),"Complete", Abs(Sum([Update])))

I want no figures to appear in the report when it is not equal to
(Sum([Update]),
would it be possible?
what syntax do I need to add to make it possible?

thanks
Click to expand...
Click to expand...
Click to expand...
 
thanks guys you give an idea it works now.

thanks a lot

Duane Hookom said:
I guess I didn't know what you meant by "no figures". I doubt this is what
you want but it meets your specs:

=IIf(Sum([Update]) <>Sum([ApprovedRL]), "No Figures", Null)

--
Duane Hookom
Microsoft Access MVP


Denver said:
= IIf(Abs(Sum([ApprovedRL]))=(Sum([Update])),"Complete", Abs(Sum([Update])))

base from this equation I want to add syntax that when a value from my
(Sum([Update])) field is not be equal to Sum([ApprovedRL]) no figures should
be appeared in the report?

I try to work on this equation but it doesn't work

IIf(Abs(Sum([ApprovedRL]))=(Sum([Update])),"Complete", &
IIf(Abs(Sum([ApprovedRL]))<>(Sum([Update])),"",Abs(Sum([Update]))))

can you help me work on this?

thanks

Duane Hookom said:
What do you mean by "I want no figures to appear in the report"?

--
Duane Hookom
Microsoft Access MVP


:

Hello everyone,

I have this syntax in this control source
= IIf(Abs(Sum([ApprovedRL]))=(Sum([Update])),"Complete", Abs(Sum([Update])))

I want no figures to appear in the report when it is not equal to
(Sum([Update]),
would it be possible?
what syntax do I need to add to make it possible?

thanks
Click to expand...
Click to expand...
Click to expand...
 
Denver said:
I try to work on this equation but it doesn't work

IIf(Abs(Sum([ApprovedRL]))=(Sum([Update])),"Complete", &
IIf(Abs(Sum([ApprovedRL]))<>(Sum([Update])),"",Abs(Sum([Update]))))
Click to expand...

It should not even compile because it is an invalid statement. But, from
what you show, it would appear that you intend that if the two Sums are
equal that "Complete" be displayed, and if they are not equal, that a null
or empty string be displayed, but in that second part, that if they are not
not equal (which woul be "are equal"), instead of the "Complete" requested
earlier, you want a value displayed. So, even if you remove the extraneous
"&" and make it into a valid VBA statement, it appears you are asking for an
illogical result...

Larry Linson
Microsoft Office Access MVP



__________ Information from ESET Smart Security, version of virus signature database 4050 (20090503) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top