| |

VerySource

 Forgot password?
 Register
Search
View: 10|Reply: 6

[Copy link]

1

Threads

4

Posts

5

Credits

Newbie

Rank: 1

Credits
5

 United States

Post time: 2020-2-24 18:00:02
| Show all posts |Read mode
-----------------
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?
Reply

Use magic Report

0

Threads

11

Posts

10

Credits

Newbie

Rank: 1

Credits
10

 China

Post time: 2020-5-10 18:30:01
| Show all posts
try:
select iif (ff mod 12 = 0, ff / 12, int (ff / 12) +1) as year, * from a;
Reply

Use magic Report

1

Threads

4

Posts

5

Credits

Newbie

Rank: 1

Credits
5

 China

 Author| Post time: 2020-5-27 01:45:02
| Show all posts
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? ? ?
Reply

Use magic Report

0

Threads

11

Posts

10

Credits

Newbie

Rank: 1

Credits
10

 China

Post time: 2020-5-27 20:15:01
| Show all posts
Place the control in the report footer
Reply

Use magic Report

1

Threads

4

Posts

5

Credits

Newbie

Rank: 1

Credits
5

 China

 Author| Post time: 2020-5-29 22:45:01
| Show all posts
Well, I put it in the footer of the report.
Reply

Use magic Report

1

Threads

4

Posts

5

Credits

Newbie

Rank: 1

Credits
5

 China

 Author| Post time: 2020-6-7 16:45:01
| Show all posts
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. ^_^
Reply

Use magic Report

0

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-6-17 12:30:02
| Show all posts
select device, int((month-1)/12)+1 as year from **;
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list