Access a textbox from another textbox

Is it possible to get the value of a textbox from another textbox ? I can't
seem to find a way. What I am trying to do is sum a field that is only
listed on the report. Based on several factors there are multiple rows not
displayed and what I want to do is sum all of the rows that are displayed.
If I have a textbox called txtPrice, is there a way to access that (like
=txtPrice.text) in a different textbox and then additionally do a
=Sum(txtPrice.text).
Anyone?
Thanks!
ChrisTry
ReportItems!<textboxName>.Value
Jackson
"Chris Hastings" <chrshstngs@.comcast.net> wrote in message
news:2eOdne6G48T-ivTeRVn-jQ@.comcast.com...
> Is it possible to get the value of a textbox from another textbox ? I
> can't seem to find a way. What I am trying to do is sum a field that is
> only listed on the report. Based on several factors there are multiple
> rows not displayed and what I want to do is sum all of the rows that are
> displayed. If I have a textbox called txtPrice, is there a way to access
> that (like =txtPrice.text) in a different textbox and then additionally do
> a =Sum(txtPrice.text).
> Anyone?
> Thanks!
> Chris
>|||Hi Jackson,
Thanks! That answered my question, but unfortunately didn't solve my
problem.
I'm trying to get a sum of only fields that actually appear on the report
vs. fields that are in the entire dataset. Any ideas on that one?
Thanks!
Chris
"Jackson" <jackson_num5@.yahoo.com> wrote in message
news:uLHVad$3FHA.1420@.TK2MSFTNGP09.phx.gbl...
> Try
> ReportItems!<textboxName>.Value
> Jackson
> "Chris Hastings" <chrshstngs@.comcast.net> wrote in message
> news:2eOdne6G48T-ivTeRVn-jQ@.comcast.com...
>> Is it possible to get the value of a textbox from another textbox ? I
>> can't seem to find a way. What I am trying to do is sum a field that is
>> only listed on the report. Based on several factors there are multiple
>> rows not displayed and what I want to do is sum all of the rows that are
>> displayed. If I have a textbox called txtPrice, is there a way to access
>> that (like =txtPrice.text) in a different textbox and then additionally
>> do a =Sum(txtPrice.text).
>> Anyone?
>> Thanks!
>> Chris
>>
>|||I think you can do that by adding a footer and in one of the footer fields
right click and go into expressions.
There you'll be able to sum up the fields that appear in the reports detail
area. So you can type this
=Sum(Fields!Field1.Value)+Sum(Fields!Field2.Value) etc.
Hope that helps,
Jackson
"Chris Hastings" <chrshstngs@.comcast.net> wrote in message
news:v5WdncrjzMToofTeRVn-pg@.comcast.com...
> Hi Jackson,
> Thanks! That answered my question, but unfortunately didn't solve my
> problem.
> I'm trying to get a sum of only fields that actually appear on the report
> vs. fields that are in the entire dataset. Any ideas on that one?
> Thanks!
> Chris
> "Jackson" <jackson_num5@.yahoo.com> wrote in message
> news:uLHVad$3FHA.1420@.TK2MSFTNGP09.phx.gbl...
>> Try
>> ReportItems!<textboxName>.Value
>> Jackson
>> "Chris Hastings" <chrshstngs@.comcast.net> wrote in message
>> news:2eOdne6G48T-ivTeRVn-jQ@.comcast.com...
>> Is it possible to get the value of a textbox from another textbox ? I
>> can't seem to find a way. What I am trying to do is sum a field that is
>> only listed on the report. Based on several factors there are multiple
>> rows not displayed and what I want to do is sum all of the rows that are
>> displayed. If I have a textbox called txtPrice, is there a way to access
>> that (like =txtPrice.text) in a different textbox and then additionally
>> do a =Sum(txtPrice.text).
>> Anyone?
>> Thanks!
>> Chris
>>
>>
>|||Hi again Jackson,
Thanks for taking the time.
A little background.
I have a query that joins multiple tables (I can't do subselects because my
ODBC driver doesn't support them), so for a given item that I want, I need
information from 4 other tables, for which I have to use joins. I group by
the main item and then use the First(field!..) to display the information
and I hide my detail line. By the way, one of the pieces of information I
want from another table is just a count, but in any case, there could be 1
record for an item or 1000, depending on the sub tables. It's annoying...
Anyway, the main item table has a price in it, and I want to sum all of the
prices for the items for a customer. The problem is that each item is
actual between 1 to 1000 actual records because of the other joins. So, my
Sums are completely goofy. The mental block I am trying to overcome is that
I can see exactly what I want to sum on the screen (because it's in a group
header and there are no detail lines) but I can't for the life of me figure
out a way to either sum the information that appears only on the report, or
sum pieces of the recordset based on other aggregate functions (like first
or count).
I'm contemplating forcing them to move their data to SQL, but I'm thinking
that is unlikely...
"Jackson" <jackson_num5@.yahoo.com> wrote in message
news:u%23Vke9$3FHA.2816@.tk2msftngp13.phx.gbl...
> I think you can do that by adding a footer and in one of the footer fields
> right click and go into expressions.
> There you'll be able to sum up the fields that appear in the reports
> detail area. So you can type this
> =Sum(Fields!Field1.Value)+Sum(Fields!Field2.Value) etc.
>
> Hope that helps,
> Jackson
>
> "Chris Hastings" <chrshstngs@.comcast.net> wrote in message
> news:v5WdncrjzMToofTeRVn-pg@.comcast.com...
>> Hi Jackson,
>> Thanks! That answered my question, but unfortunately didn't solve my
>> problem.
>> I'm trying to get a sum of only fields that actually appear on the report
>> vs. fields that are in the entire dataset. Any ideas on that one?
>> Thanks!
>> Chris
>> "Jackson" <jackson_num5@.yahoo.com> wrote in message
>> news:uLHVad$3FHA.1420@.TK2MSFTNGP09.phx.gbl...
>> Try
>> ReportItems!<textboxName>.Value
>> Jackson
>> "Chris Hastings" <chrshstngs@.comcast.net> wrote in message
>> news:2eOdne6G48T-ivTeRVn-jQ@.comcast.com...
>> Is it possible to get the value of a textbox from another textbox ? I
>> can't seem to find a way. What I am trying to do is sum a field that
>> is only listed on the report. Based on several factors there are
>> multiple rows not displayed and what I want to do is sum all of the
>> rows that are displayed. If I have a textbox called txtPrice, is there
>> a way to access that (like =txtPrice.text) in a different textbox and
>> then additionally do a =Sum(txtPrice.text).
>> Anyone?
>> Thanks!
>> Chris
>>
>>
>>
>