Topic: Show time on report
I can't display the time on an am/pm report, it always displays in PM. How can I do to have the time in the morning and in the afternoon.
Sabine
Re: Show time on report
Hi Sabine,
Please attach your project or example
Re: Show time on report
Here is the project in question, there is one out of two dates that is not displayed correctly.
I would like it to display in the morning or afternoon.
Post's attachments
Ma pêche.zip 720.95 kb, 117 downloads since 2022-06-07
4 2022-06-07 14:56:42 (edited by domebil 2022-06-07 14:56:59)
- domebil
- Member
- Offline
Re: Show time on report
Re: Show time on report
Thank you domebil but the time is not displayed correctly, when I type 10:15 it displays 10:12 and for 10:00 it displays 22:00.
Re: Show time on report
Please try ...
Post's attachments
Ma1.zip 718.03 kb, 125 downloads since 2022-06-07
Re: Show time on report
It's great sparrow, the display is perfect in am and pm.
Thanks a lot.
Sabine
8 2022-06-08 07:52:40 (edited by sdpc62 2022-06-08 07:57:42)
Re: Show time on report
I am facing a display problem for a second hour in the report.
The first hour works very well but when I wanted to add a second Combo I get an error in the report and I can't find where it comes from. If anyone wants to take a look at it that would be great.
Post's attachments
Peche.zip 721.07 kb, 112 downloads since 2022-06-08
9 2022-06-08 08:10:20 (edited by sparrow 2022-06-08 08:50:33)
Re: Show time on report
Hi Sabine,
The Heure2 field in your database is NULL . Therefore the error.
When you check a date and enter a value, you still need to save it.
For reporting, you take data from the database, not from the screen.
This is how you can handle and avoid the error. Displays ' -- --' if field is NULL or time am/pm if present value.
In example Dorade - Heure2 is NULL
Roussette - Heure2 is time
Post's attachments
Peche2.zip 718.78 kb, 125 downloads since 2022-06-08
Re: Show time on report
Actually, I didn't know how to do it. It works great.
Thank you very much sparrow, I remember the lesson.