Calculated fields on subform grid show different from Query
I have a form with 1 subform. The subform has a grid with 2 calculated fields. The calculation is correct in the SQL query, but most of the calculations show on the grid as way off. If any one could look at my example and detect an error, I would appreciate it.
Debian 9 LibreOffice 5.2.2.2 Data base is hsqldb 2.3.4 wizzardC:\fakepath\STUFF.odb
You can upload your sample file here. To do this, edit your initial question and click the paper clip icon (attachment).
I seem to have trouble adding a zip file.
The zip file is not on the list
Hello,
Just change the extension from
.zip
to.odb
and note that in your edited post.Also, is there a reason you are using such an old version of LO?
I clicked on the paperclip, clicked on my zip file, it showed up and i clicked ok. But zip was not an accepted file. or maybe it just didn't get there yet
zip
is not allowed. Change this to something acceptable likeodb
and when we download to review, as you will note this change, we will change it back tozip
so it will work properly. See my previous comment. This is commonly done for this situation.There is a reason, Sometimes the db doesn't work the same after an upgrade. I will try the extension Change
@Pumper,
Have worked with split since LO v4.3.x and now in the 6.x series. Yes, there is an occasional problem but have not held upgrades for that many versions. Your decision. Just didn't understand.
I can't seem to get the zip file small enough. The .odb 1,5 m and when I zip it, it is still 1.5m ??
I will make a new embedded db file and upload.