Creating an expression from multiple Table entries

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

Guest

I have two Tables 1.)Proj Budget 2.)Budget Plan. Proj Budget has one entry
value for the overall budget. The Budget Plan Table has multiple entries that
their sum is the planned budget. I want to have a report that calculates the
difference between the Tables (Proj Budget-single entry) and (Budget Plan -
summed multiple entries). Any ideas?

Thanks

Joe
 
You can set the grouping in your report to the field that joins your two
tables. In the group header or footer, you can use an expression like:

=[FieldFromSingleEntryTable] - Sum([FieldFromMultiEntryTable])
 
Duane,

Thanks for the response but I don't understand the first part "You can set
the grouping in your report to the field that joins your two tables." I tried
the equation in the group footer and prompts me for the value for the
[FieldFromSingleEntryTable] so it thinks its a variable. I even tried to used
the expression builder so that it would point to the propoer tables but in
view it gives an Error for the value.


Duane Hookom said:
You can set the grouping in your report to the field that joins your two
tables. In the group header or footer, you can use an expression like:

=[FieldFromSingleEntryTable] - Sum([FieldFromMultiEntryTable])

--
Duane Hookom
MS Access MVP
--

Joe Banach said:
I have two Tables 1.)Proj Budget 2.)Budget Plan. Proj Budget has one entry
value for the overall budget. The Budget Plan Table has multiple entries
that
their sum is the planned budget. I want to have a report that calculates
the
difference between the Tables (Proj Budget-single entry) and (Budget
Plan -
summed multiple entries). Any ideas?

Thanks

Joe
Click to expand...
Click to expand...
 
Maybe you should provide some actual table and field names. The ones I
provided are simply "place holders" for your real field names.

--
Duane Hookom
MS Access MVP
--

Joe Banach said:
Duane,

Thanks for the response but I don't understand the first part "You can set
the grouping in your report to the field that joins your two tables." I
tried
the equation in the group footer and prompts me for the value for the
[FieldFromSingleEntryTable] so it thinks its a variable. I even tried to
used
the expression builder so that it would point to the propoer tables but in
view it gives an Error for the value.


Duane Hookom said:
You can set the grouping in your report to the field that joins your two
tables. In the group header or footer, you can use an expression like:

=[FieldFromSingleEntryTable] - Sum([FieldFromMultiEntryTable])

--
Duane Hookom
MS Access MVP
--

Joe Banach said:
I have two Tables 1.)Proj Budget 2.)Budget Plan. Proj Budget has one
entry
value for the overall budget. The Budget Plan Table has multiple
entries
that
their sum is the planned budget. I want to have a report that
calculates
the
difference between the Tables (Proj Budget-single entry) and (Budget
Plan -
summed multiple entries). Any ideas?

Thanks

Joe
Click to expand...
Click to expand...
Click to expand...
 
Back
Top