Results 1 to 2 of 2

Thread: Access Subreports

  1. Nov 1st, 2005, 06:52 AM #1
    vonoventwin
    vonoventwin is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2005
    Location
    Long Island, NY.
    Posts
    353

    Question Access Subreports

    I have a main report with three subreports (JANSUB, FEBSUB, MARCHSUB) They all have a textbox on the report that calculates a sum of costs (ex of txtJan is =SUM(COST) ) I have a total of $10,000 on my main report and I want a text box that minuses. I want it to take $10,000 (a given value) minus txtJan, minus txtFeb, minus txtMarch.

    So how do I get my textbox to minus original txtValue-txtJan-txtFeb-txtMarch?? Thanks!
    Last edited by vonoventwin; Nov 1st, 2005 at 07:54 AM.
    Reply With Quote Reply With Quote
  2. Nov 1st, 2005, 08:29 AM #2
    kaffenils
    kaffenils is offline
    Fanatic Member kaffenils's Avatar
    Join Date
    Apr 2004
    Location
    Norway
    Posts
    946

    Re: Access Subreports

    Quote Originally Posted by vonoventwin
    I have a main report with three subreports (JANSUB, FEBSUB, MARCHSUB) They all have a textbox on the report that calculates a sum of costs (ex of txtJan is =SUM(COST) ) I have a total of $10,000 on my main report and I want a text box that minuses. I want it to take $10,000 (a given value) minus txtJan, minus txtFeb, minus txtMarch.

    So how do I get my textbox to minus original txtValue-txtJan-txtFeb-txtMarch?? Thanks!
    txtValue-JANSUB.report.txtJan-FEBSUB.report.txtFeb-MARCHSUB.report.txtMarch... and so on.


    Tutorial: SQL Server recursion
    Small ADO demo
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width