combo box

[Chi]

Hi

I have a textfield named CEUCredit and I changed it to combo box. Its data
source came from the table named CREDIT that has CREDITID and CREDITNUMBER.
The report looks fine (it shows the CREDITNUMER on the detail section).
However, the SUM ([CREDITNUMBER]) is wrong since it added the number of
CREDITID instead of CREDITNUMBER. Would you please show me how I can make it
sums the CREDITNUMBER?

Please help

Thank you
Chi

 

[Duane Hookom]

I assume you are storing CREDITID in the field. You should add the CREDIT
table to your report's record source. This will allow you to add CREDITNUMBER
to the recordsource so it can be summed in the report.

 

[Chi]

Hi Duane,

Thank you so much! I works perfectly.

I assume you are storing CREDITID in the field. You should add the CREDIT
table to your report's record source. This will allow you to add CREDITNUMBER
to the recordsource so it can be summed in the report.

--
Duane Hookom
Microsoft Access MVP

Hi

I have a textfield named CEUCredit and I changed it to combo box. Its data
source came from the table named CREDIT that has CREDITID and CREDITNUMBER.
The report looks fine (it shows the CREDITNUMER on the detail section).
However, the SUM ([CREDITNUMBER]) is wrong since it added the number of
CREDITID instead of CREDITNUMBER. Would you please show me how I can make it
sums the CREDITNUMBER?

Please help

Thank you
Chi