RE: Report Equation Access 2003

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" wrote:

= 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" wrote:

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

--
Duane Hookom
Microsoft Access MVP


"Denver" wrote:

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

.

Relevant Pages

  • Re: if >= to, then...
    ... Did you try to use John's SQL syntax? ... Microsoft Access MVP ... "Duane Hookom" wrote: ... I'm transferring a very complex file from excel into Access, ...
    (microsoft.public.access.queries)
  • RE: Calendar Error (Duanes Calendar)
    ... If there would be no records then why report this? ... Microsoft Access MVP ... "Duane Hookom" wrote: ... When I run the query with the Criteria listed from Col1 and Col ...
    (microsoft.public.access.reports)
  • RE: runtime error record is deleted
    ... Microsoft Access MVP ... Should I run an update query to update all of the tables or should I load ... "Duane Hookom" wrote: ... Public Function ParseText(pstrText As String, intElement As Integer, _ ...
    (microsoft.public.access.queries)
  • RE: Subtract on a report based on QRY cross table
    ... Microsoft Access MVP ... "Duane Hookom" wrote: ... cross tab query, this one, the sub report, i would like, on Total, to show ... PlusMinus field in "a table with those accounts only with groups number" that ...
    (microsoft.public.access.reports)
  • RE: #Error from Count
    ... HasData is a property of the report. ... Microsoft Access MVP ... "Leif" wrote: ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)