Subject Re: Calculated field and Query From Mervyn Bick <invalid@invalid.invald> Date Sun, 9 Dec 2018 22:42:14 +0200 Newsgroups dbase.getting-started On 2018-12-09 7:28 PM, Dirk wrote: > > Mervyn > > bedankt, but > > i explained not very well > > that's a part of the sql   sql = ("select > volgnr,aanvang,datum,aardkosten,verschil,eenheidsprijs,totaalkost,eenheidvast,kostvast,totalekost,einde > > > the fieldnames from the table, i ordered them in this way to show these > on excel, normally i created 3 calculated fields for sum, > i tried to put the calculated fields among the other fields in the sql > to get thes on the excel file, but :) not in the table not in the sql > so i am more and more thinking how to get the calculated fields on the > right place in the excel file; > so suppose is a matter to find a way in excel > > for now i create 3 more field in table to get the result of calculation > > never the less, thanks for prompt response The fields in your SELECT statement can be in any order.  You can place calculated fields anywhere in the field list provided the calculations are based on fields in the table or from another table which is JOINed to the main table. Exactly what calculations do you need to execute in order to create the three calculated fields? Mervyn.