Amedeo

ook. How may I reformat the date in the SQL query as you said?

With executesql script, date Is in format MM-DD-YYYY... How May I convert It to DD/MM/YYYY?

Great!! That exatlly what i was looking for!

I have three fields that i call: apples, bananas and oranges... and there's a fourth field called: basket... I want to know which fruit or fruits is/are present in the greatest quantity in the basket. Now I'll give you some examples: 1st case: apples = 3, bananas = 2 and oranges = 1. In the basket I would like "apples" will be written down because apples are more than bananas and oranges. The same needs to be if bananas are more then apples and oranges. 2nd case: apples = 3, bananas = 1 and oranges = 3. In the basket now I would like "apples and oranges" will be written down because they are the fruits in greater quantities and are in equal number. 3rd case: apples = 3, bananas = 3 and oranges = 3. In the basket it shows "apples and oranges and bananas" because they are all in equal number. Must show empty when everything is 0 I know I have to use Cases and it works for me if one fruit is greater than the others, but not if there are two more fruits. Help me please 😭

I Need to keep them separated because i have a table of teacher and a table of tutors that also have global field for creating accounts with different privileges and other datas. But there's a format of an other table where the students will select for a field the name of a tutor or teacher from the same value list

How may I create a value list with all names i have in a table and others in an other one.. example.. table A: Mark, John; Thomas; Anna. Table B: Julia, Michael, Helena; Sophia. The risult of value list needs to be: Mark, John; Thomas; Anna,Julia, Michael, Helena; Sophia.

Yeah seems to work great! Thanks. So now i need to find a solution to escape from a record and return dashboard if i set to private a record but another user is viewing that record changed to private.. to avoid user see <<no access>>

I think it'll be something very very complicated because i don't know how to create it with all this variables for supervisors (because only them have this problem)

Yeah that could be a part of the solution and seems to be great... but i have an other problem... there are the supervisors (with their own privilege) that need to view all clients created by the employees but they may create also their own ones. So how i may give the possibility to the supervisor to make public/private record but to view all the records created by the employees? the 2 priviledge sets are: - employees: create their clients and may share the clients with the other. No employee can view an other emploee's client if not public - supervisor: must view all clients of employee but they may private/public their own client to all and other supervisors i know that is something strange. Thanks

I have a question about how to solve this ... I have a group of employees who create their own clients (viewed also like list) and which other employees cannot access with security level filters and privilege set customization (based on created by and then Get(AccountName)...but I would like to do this: if a record is "flagged" public the other employees can also view that record, while if I want to make it private I do not apply the flag and only the owner can view the record ... what can I do? Thanks