I'm using Access 2000, and selecting distinct values from a table to use in a combo box. It's the combination of 3 fields, the first 2 are text, the 3rd is numeric. The sql looks like this:
SELECT DISTINCT pcn.cost_center_code, pcn.fund, pcn.fund_num
Seems very straight forward to me. But the results won't show the 3rd field, fund_num. It appears there is a row for it, but the number doesn't show up in the results. Here is an example of the results.
They should be
12100 D 0
12100 E 0
12100 E 3
I can understand why maybe the 0's wouldn't show up, but what about the other numbers?
Has anyone had any similar problem? I'm not sure what to try. (The field has to stay numeric. I can't change it in the table to be text.)
Thanks. Frances Donahoe