Create an additional column in query/table?

Hi All,

Can i create an additional column in Access, based on certain condition such as if condition = True,

than Total amount + 200?

How could I write that in my VBA?

Thanks!

Hello,

Each column in access is a field of your table. I think this is what you want to do, you have a field name Total Amount,
you want that cost to be added 200 if the field condition=True right?

Ok just do the following, if you are using your condition field as the combobox, "It means that you are picking from a list" just goto events, after update and

put this

If condition=True than Cost= Price + 200
If condition=False than Cost=Price
End if
Me.refresh

I think this should work.... What the concept is when the condition is true the field Total Amount will update automatically what you picked...