unrelted table used for a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to use an unrelated table in a report that I am creating against
a query. I need this information for calculations. How can I do that?
 
You really aren't giving us much information. You can use domain aggregate
functions, controls with row source properties, code, subreports, and
possibly other methods to access information from tables that are not
included in the report's record source.
 
Sorry for the slight information. I am trying to run a report that will start
with a beginning balance that is listed in a separate table than where the
query for the report is taken. So there is no relationship between the 2
tables. I will also need to calculate a running sum from that amount that is
listed in the separate table. So I want the amount listed on the report, but
I also want to use that amount to calcuate a running sum on the report. I
hope this makes sense.
 
Yes. I know that I can add it as an aggregate function, however I'm having
problems figuring out how to use it to calculate a running sum with that as
the beginning balance. Any ideas?
 
Can you set a running sum on a text box (txtRunSum) and bind your beginning
balance to a text box (txtBegBal) and then have another text box with a
control source of:
=txtBegBal + txtRunSum
 
I'm confused as how I would set this up. If I use a table that is not related
or not in the original query, when I run the report, it asks for a parameter
for that control source. I've done a lot of reports, but have not come across
trying to do this. Is there somewhere on Microsoft's site that would explain
this? Thank you for your help.
 
Have you successfully added a text box with a control source of a domain
aggregate function such as DLookup() or DSum() that returns your beginning
balance?
 
Back
Top