Expression data selection trouble

[JoeM]

Probably because your ID field is set to Integer or Long, which does not allow decimals. You would need to change the data type.


I would recommend deleting and recreating your Combo Box. It can get messy to change all the Properties "on-the-fly", and it is usually just easier to rebuild it after you have made your changes to the field.

[CJ_London]

if ticketprice is a combo with a rowsource something like

SELECT ID, Price from tblPrices

with bound column 1 and columncount 2

then your calculation needs to be

[TicketsSold]*[TicketPrice].Column(1) AS TotalCash

columns start at 0, whilst bound starts at 1, (so column(1) is bound column 2) a bit confusing but there you are

Not sure if this works in a query but will in a form

[moocho992345]

I changed the data type to currency, which should allow for decimals, but it doesn't. When you try to enter a decimal, it corrects itself into a whole number. I tried that calculation in my form and it left the combo box empty with no selections.