Subject Re: data modules - calculated fields From Gaetano De Luisi <gaetanodd@hotmail.com> Date Wed, 08 Jul 2020 21:56:59 -0400 Newsgroups dbase.getting-started Correct, and your example did not have the file name but the table name, that's why it worked. Once I removed the file name extension it worked for me too. I'm only slowly getting back into this so I'm sure there will be other issues that I will be slow to click on, as ultimately, I am only a hobbyist coder Cheers, Gaetano. Akshat Kapoor Wrote: > Good Evening GaeTano, > > > PS, select energydata.* or energydata.dbf.* from "energydata.dbf" does not work for me, neither at command line level, nor in the designer. > > Strange as the the sql I had posted had been checked and then posted. > > > > The following command produces an "invalid field name error": > > select energydata.energyProducedWh from "energydata.dbf" > > At your leisure try the above command again. There could have been a > typo when you had typed it. Because if the following works then the > above should also work > > > > But this one works, I need to omit the file extension in the file name: > > select energydata.*,energyProducedWh*12 as power from "energydata" > > Regards > Akshat