SELECT Table.field1, Table.field2, iif(Table.field1="Mike", Table.field2*.025, Table.Field2*.05) as Field3 FROM Table
You must open it in design view.
The iif() makes it all.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only