By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,093 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

Subtotal on Report..reference issue

P: n/a
Hi:

I am developing a report, and have run into a reference snag.

I have subtotals which i generate on the report, and have named "tasksum", which represent
the number of hours an individual has spent on a specific task. I wish to sum them when
the individuals name changes, and have written the command:

=Sum([tasksum])

on the appropriate footer. The trouble is that for some reason Access does not recognize
the name. I know its set right in he properties of the subtotal and all, so I assume its a
problem with syntax.

Can someone please suggest the right syntax for this kind of reference.

Thanks

John Baker
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
If [tasksum] is a calculated field that is not included in the query,
then you need to include the Report object reference. Otherwise Access
thinks you are refering to a query/table field called [tasksum].
Try Reports!ReportName!tasksum.

Mike Storr
www.veraccess.com

John Baker wrote:
Hi:

I am developing a report, and have run into a reference snag.

I have subtotals which i generate on the report, and have named "tasksum", which represent
the number of hours an individual has spent on a specific task. I wish to sum them when
the individuals name changes, and have written the command:

=Sum([tasksum])

on the appropriate footer. The trouble is that for some reason Access does not recognize
the name. I know its set right in he properties of the subtotal and all, so I assume its a
problem with syntax.

Can someone please suggest the right syntax for this kind of reference.

Thanks

John Baker

Nov 12 '05 #2

P: n/a
Mike thanks..thats what I needed!!!

Mike Storr <no****@noname.con> wrote:
If [tasksum] is a calculated field that is not included in the query,
then you need to include the Report object reference. Otherwise Access
thinks you are refering to a query/table field called [tasksum].
Try Reports!ReportName!tasksum.

Mike Storr
www.veraccess.com

John Baker wrote:
Hi:

I am developing a report, and have run into a reference snag.

I have subtotals which i generate on the report, and have named "tasksum", which represent
the number of hours an individual has spent on a specific task. I wish to sum them when
the individuals name changes, and have written the command:

=Sum([tasksum])

on the appropriate footer. The trouble is that for some reason Access does not recognize
the name. I know its set right in he properties of the subtotal and all, so I assume its a
problem with syntax.

Can someone please suggest the right syntax for this kind of reference.

Thanks

John Baker


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.