combo box

  • Thread starter Thread starter Chi
  • Start date Start date
C

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
 
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.
 
Hi Duane,

Thank you so much! I works perfectly.

Duane Hookom said:
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


Chi said:
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
Click to expand...
Click to expand...
 
Back
Top