Amount for every SELECTED item in combo box

[martixz]

I have a problem working with MS Access. There is a table named "40" and a form that fills that table "40 valdymas". In that form combobox "Pavadinimas" fills the table field "Pavadinimas". I need to add a possibility to specify amount of each SELECTED combobox item (for example, 2 of Oligochaeta, 5 of Scorpiones) and expression in table field "Pavadinimas" should be exaclty: 2*Oligochaeta, 5*Scorpiones etc.
I am not sure whether the problem is explained correctly, but I can try to clarify if it is needed. I would be very thankful.
Screens:

[ranman256]

The query showing the list will need to have the count too.
select #, item, count([item]) from table

[ssanfu]

From the image, it looks like the field "Pavadinimas" is a multi-value field (MVF).
You might want to rethink this strategy. No experienced programmer I know of uses MVFs. I never use them.
They are a pain to display/report, usually requiring code to do anything useful with them.

I'm just saying...........

[martixz]

Any more suggested solutions to this problem? Still can't solve it.

[June7]

Don't use MVF's. Otherwise, learn how to build queries with them. https://support.office.com/en-us/art...E9BEBBEC31#bm7

[ssanfu]

You also need a field to store the quantity (ie 2 of Oligochaeta, 5 of Scorpiones).

You can DISPLAY the quantity with the options in the combo box "Pavadinimas" by concatenating the quantity to the combo box option, but somewhere there needs to be a field that stores that quantity.

From the sound of your description, you do not have a normalized table structure...... But since I have not seen your table structure, this is just a guess..