I HAVE A COMBO BOX. I ENTERED VALUES:
1ST COLUMN 2ND COLUMN Amethyst $100 CareGuard $500
in my form I am able to choose either Amethyst of CareGuard from the dropdown list and it shows the corresponding value.
However, I want to create a query and report that shows the total charged for each item. In my query, I only see Amethyst, but not $100.
Any ideas?
Thanks,
John