Calculations with forms/subforms

  • Thread starter Thread starter Gina K.
  • Start date Start date
G

Gina K.

Hello!
I'm new to Access ( a former Lotus Approach user) and I've
come to learn that Access is far superior in just about
every way. I have, however, one problem that continues to
exasperate me in every database I try to write (I
eventually get it, but don't ask me how)!
I know it should be simple, but I just can't seem to grasp
this: I have a subform with vacation dates and hours. I
added a field in my subform called SumScheduled to sum the
vacation hours an employee has scheduled. (I placed this
calculated field in the footer of the subform and it works
great.) However, when I try to refer to this SumScheduled
field on my main form (which said subform is a part of) I
always get either the Error# or the #Name$ error
returned. I checked out Northwind and two other
applications in which I have used this successfully and I
try use them as a guide for this new application but to no
avail.
This works in my Orders application but not in my Vacation
application:
=[LineItem Subform].Form![ORDERTOTAL]

I also tried using the expression builder so that I know
I'm not making typographical errors, but that didn't work
either!
Can anyone give me some pointers? Like I said, I know
this is so basic, but I'm losing sleep over this!
Thanks in advance.
 
I finally figured that one out (duh), but this raises a
new question:
I have the SumPaidHours calculation working (in the
subform footer), but when I try to add another similar
field in the footer (SumUnpaidHours) BOTH fields return
#Error. (When I delete the SumUnpaidHours field, the
SumPaidHours returns the correct value again.)
Can there be only one sum field in a footer?
Thanks!
Gina
 
Back
Top