here is my calc in a query that when run returns nothing to the form.
ListVarianceUS: IIf([StaticListCDN] Is Null,0,(([Forms]!
[frmUserPartListCostingMain]![txtExcRate]*[StaticListCDN])-
[StaticListUSD])/([Forms]![frmUserPartListCostingMain]!
[txtExcRate]*[StaticListCDN]))
why?
If *any* of these form references or fields are NULL the entire expression
will be NULL. What's in txtExcRate? Is frmUserPartListCostingMain in fact open
at the time this query is run? Are StaticListCDN and StaticListUSD fields in
the table, or other form references - and might either be NULL?
--
John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
Yeah i had thought of that. none are null. or at least shouldnt be.
i looked up the error i was getting turned out to be a different
problem all togther. i had spaces in the directory i was working in
and the new 2007 version of access doesnt like the spaces. so i
renamed the folder and it was all fine afterwards. i cant believe the
pains that MS creates with each new version.
oh well.