Math Functions in Access 2002 Form give #Error

[azemc2]

I have a form displaying continuous records and am trying to sum up totals on the form footer. The continuous form detail shows up fine. The problem is that I want to total values for each fiscal year in the form footer and I get #Error.
The table data looks like this:

BILLDATE KW KWH DOLLARSBILLED
1/31/02 200 10000 $450
2/28/02 450 18000 $600
etc, etc

I have named the text box that will hold the sum amount something totally different that the [Field] in the control statement, but I am still having problems. I have done this in the past with Access 2000 without any problem, but now I am using Access 2002 and it does not work. I am not quite ready to jump off the roof yet, but getting close! Has anyone come across this problem? Any help is appreciated.

 

[SnaveBelac]

Once or twice I have seen Access change the variable names in an expression to match that of the textbox name. I have no idea why this occurs and I feel it is unlikely that is whatis happening here but I thought I should mention it.

What I am saying is, check your expression to make sure Access has not changed anything without your knowledge when you modified the name.



----------------------------
SnaveBelac - Adventurer

http://www.hostpipe.co.uk

 

[azemc2]

Thanks, SnaveBelac. I've checked for that and from what I can see the variables remain the same.

 

[TheAceMan1]

How are ya azemc2 . . . . .

We can help you better if you post the code in the control!

Have you tried [blue]DSum![/blue] . . . . something like:

[blue]= DSum("[FieldName]", "TableName", "[FieldName] >= #" & BeginDate & "# And [FieldName] <= #" & EndDate & "#")[/blue]

See Ya! . . . . . .

 

[azemc2]

Sorry for the late response...I've been out of town. Thank you both. It turned out to be a simple fix. I had a problem with field definitions.