Democratic Underground Latest Greatest Lobby Journals Search Options Help Login
Google

Access Gods, Excel Gods. MERGE!! (formula/expression builder problem)

Printer-friendly format Printer-friendly format
Printer-friendly format Email this thread to a friend
Printer-friendly format Bookmark this thread
This topic is archived.
Home » Discuss » The DU Lounge Donate to DU
 
Hawkeye-X Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jul-19-04 12:17 PM
Original message
Access Gods, Excel Gods. MERGE!! (formula/expression builder problem)
Edited on Mon Jul-19-04 12:25 PM by HawkeyeX
Hi, In Excel, the formula looks like this:
=IF(F172<>0,SUM(E171-E172,F171-F172),"")


And I wrote it in Access' Expression Builder
N - Inches Used: IIF( [NAEDiff]<>0,
SUM([NWest]-[NAWDiff], [NEast]-[NAEDiff]),"")

However, when I try to get out of it, I get this error:
"The expression you entered has a function containing
the wrong number of arguments.

Wonder what I am doing wrong?

Hawkeye-X
Printer Friendly | Permalink |  | Top
Cocoa Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jul-19-04 12:23 PM
Response to Original message
1. typo in first argument?
you have <> 0, which is not a complete sentence.


Printer Friendly | Permalink |  | Top
 
Hawkeye-X Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jul-19-04 12:25 PM
Response to Reply #1
2. Uh...
I made an error.. The whole thing is complete.. it's just the damn brackets.

I reformatted my message into a code snippet.

Hawkeye-X
Printer Friendly | Permalink |  | Top
 
Cocoa Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jul-19-04 12:36 PM
Response to Reply #2
3. try looking up the SUM function's syntax
Edited on Mon Jul-19-04 12:40 PM by Cocoa
in Access, it might only take one argument.

in which case, 

IIF( [NAEDiff]<>0, SUM([NWest]-[NAWDiff] +
[NEast]-[NAEDiff]),"") 

might work.

Printer Friendly | Permalink |  | Top
 
DU AdBot (1000+ posts) Click to send private message to this author Click to view 
this author's profile Click to add 
this author to your buddy list Click to add 
this author to your Ignore list Wed Oct 22nd 2014, 08:17 AM
Response to Original message
Advertisements [?]
 Top

Home » Discuss » The DU Lounge Donate to DU

Powered by DCForum+ Version 1.1 Copyright 1997-2002 DCScripts.com
Software has been extensively modified by the DU administrators


Important Notices: By participating on this discussion board, visitors agree to abide by the rules outlined on our Rules page. Messages posted on the Democratic Underground Discussion Forums are the opinions of the individuals who post them, and do not necessarily represent the opinions of Democratic Underground, LLC.

Home  |  Discussion Forums  |  Journals |  Store  |  Donate

About DU  |  Contact Us  |  Privacy Policy

Got a message for Democratic Underground? Click here to send us a message.

© 2001 - 2011 Democratic Underground, LLC