Subject Re: Calculated field and Query
From Dirk <test@test.com>
Date Sun, 9 Dec 2018 18:28:13 +0100
Newsgroups dbase.getting-started


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

dirk


Op 9/12/2018 om 16:36 schreef Mervyn Bick:
> On 2018-12-09 4:55 PM, Dirk wrote:
>> Hello goodday
>>
>> i am trying to put data from a query to an excel file
>> i was struggling with select * from kilom with this query i couldn't
>> bring on the order i would in excel list
>>
>> after two coffees i got it to replace the query with the fieldnames
>> instead of wildcart *  put in order to get in a way i like to have in
>> excel list but
>> i liketo put a couple of calculated fields in the query, but query
>> doesn't accept it ( not in the *.dbf file)
>>
>> but how to get this calc fields value in the excel file
>>
>> thanks for some advice
>>
>> Dirk
>
> It depends on what calculations you want to make but as long as you
> don't need anything fancy like trig functions you should be OK.
>
> The attached example shows the name of an existing field changed from e
> to Fahrenheidt for the rowset together with 3 calculated fields.
>
> Mervyn.
>