Trying to build an SQL that will sum the values for the particular user currently seleted...
Field 1 Field 2
This is what I got....and it works....problem is, I would like to set the WHERE Clause to whatever is currently showing on my Layout in (Field 1), so whatever shows on my layout will substitute the 'b' in the SQL).
ExecuteSQL ("SELECT Sum (Field2) FROM table WHERE Field1='b'"; "" ; "" ; "")
I need help!