vicstorm

-----------------
Equipment Month Note: I only listed a few here
-----------------
**** 6
### 15
@@@          twenty three
$$$ 12
-----------------
select device, int (month / 12) +1 as year from **;
But the consequence of this is that 12, 24, 36 have all become divisible. December should also be the first year and not the second year, and 24 should be the second year and not the third year.
how to solve this problem?

cairui1

try:
select iif (ff mod 12 = 0, ff / 12, int (ff / 12) +1) as year, * from a;

vicstorm

A text box is put in the report. I think the text box displays the sum of the expenses in a certain expense column in the report. The entire report shows the result of a query. I tried using the expression builder. It can also be said that it is written in the source of the control:
= sum ([totalinRmb])
Why is it wrong? ? ?

cairui1

Place the control in the report footer

vicstorm

Well, I put it in the footer of the report.

vicstorm

It is my fault. I didn't see the original report footer can be pulled away, and there can be things inside. I thought the page footer was the last. I'm wrong. :(
Beginners have made many stupid mistakes.
I want to thankcairui1() for giving me a lot of help. ^_^

luokjm

select device, int((month-1)/12)+1 as year from **;