Bonjour
I have two tables one that is filled with the NAME and AMOUNT projects and another for entering money requests. I want us to be able to choose in the 2nd the NAME of the project and that the amount is displayed automatically. I search but I don't see, I tried SQL but it doesn't work. Thank you
In my example I want the value 50 and not both,
SQL...
Re: SQL...
WHY NOT SUM ?
- Attachments
-
- Capture d'écran 2023-09-06 170106.png (175.51 KiB) Viewed 2516 times
Re: SQL...
Hi,
I would think this is a bug. And you should post it in that subforum.
On the other hand, we can see, that it's a lookup and as this, the value shown could also be text. But: If you as the user decide to ask for the column sum, there shoule be one. As this: Bug?!
Olaf
I would think this is a bug. And you should post it in that subforum.
On the other hand, we can see, that it's a lookup and as this, the value shown could also be text. But: If you as the user decide to ask for the column sum, there shoule be one. As this: Bug?!
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view