Re: Help with an Expression

This worked! Thank you so much!

John Spencer wrote:
What value is stored in CallDirection?
Is it a number, text (Inbound), a boolean value (true/false)?

Perhaps you could share the SQL of the query you are using to generate the
data for the report?

Do you have the field CallDirection in your report?

If so, and it holds the word "Inbound" then

=Sum(IIF(CallDirection="Inbound",CountOfCallDirection,Null))
and
=Sum(IIF(CallDirection="Outbound",CountOfCallDirection,Null))

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Here's my situation. I have a parameter query (for date specific) set up to
track all inbound and outbound calls. Call Direction is the column heading
[quoted text clipped - 15 lines]
since I'm newer to Access and not real experienced with expressions, I'm
stuck. Any suggestions, would be great! Thanks!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200808/1

.

Relevant Pages

  • Re: Mysterious Parameter Added??
    ... "John Spencer" wrote: ... you are not returning that value in the query. ... Did you check the filter and sort properties of the report? ... -- open the query in SQL view and copy the SQL statement ...
    (microsoft.public.access.reports)
  • RE: Login failed for user sa
    ... you are getting hacked...no SQL doesn't record the address of the attempt. ... Throw Network monitor on the SQL server and start sniffing all inbound ... > can't understand why SQL doesn't log the ip address of login attempts. ...
    (microsoft.public.sqlserver.security)
  • Re: Mysterious Parameter Added??
    ... "John Spencer" wrote: ... you are not returning that value in the query. ... Did you check the filter and sort properties of the report? ... -- open the query in SQL view and copy the SQL statement ...
    (microsoft.public.access.reports)
  • Re: Help with an Expression
    ... Is it a number, text (Inbound), a boolean value? ... Perhaps you could share the SQL of the query you are using to generate the data for the report? ... Do you have the field CallDirection in your report? ... that states if the call was inbound or outbound. ...
    (microsoft.public.access.reports)
  • How do you create a server publishing rule for SQL 2000?
    ... I created a protocol def opening 1433 inbound but am ... My SQL 2000 ... server is also a NAT client of the ISA firewall. ...
    (microsoft.public.isaserver)