Ask Your Question

how to make a computed field in query within base [closed]

asked 2014-08-25 21:22:37 +0200

updated 2020-08-07 03:01:14 +0200

Alex Kemp gravatar image

Table.Amount = num calculate new field: Tax = Amount * 0.2

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-03 10:38:45.976601

1 Answer

Sort by » oldest newest most voted

answered 2014-08-29 20:40:40 +0200

ratrace gravatar image

I think it is necessary to use sql mode to set up your query and be able to make a calculated field.

edit flag offensive delete link more


Can someone explain how to go about doing this in SQL? I have a table that has customer purchases entered as they purchase. I want to be able to Query and have a sum of those purchases only for the selected customer.

Sparksvonrou gravatar imageSparksvonrou ( 2015-06-19 07:12:45 +0200 )edit

Question Tools

1 follower


Asked: 2014-08-25 21:22:37 +0200

Seen: 119 times

Last updated: Aug 29 '14