Recent content by Gedy

  1. G

    Union all and group by

    =DLookUp("[SumOfExpr1001] ";"[Výpočet vaplacené peníze od číšníků Dotaz]";"[Personál jméno] ='" & [Jméno].[Column](1) & "'") is working :D Thank you very much :)
  2. G

    Union all and group by

    actual
  3. G

    Union all and group by

    Yes :) The form is bound to the table. Some fields need to be entered manually. So he selects a name from the list (text field), it is written into the table. I need it according to the name, it looked up the information from the query and showed the amount according to the name.
  4. G

    Union all and group by

    I tried different expressions. For example: =DLookUp("[Výpočet vaplacené peníze od číšníků Dotaz]![ Personál jméno]";"[Výpočet vaplacené peníze od číšníků Dotaz]";"[Jméno_Tabulka výplaty manažer 1].[Column](1)"="[Výpočet vaplacené peníze od číšníků Dotaz]![Personál jméno]") It was showing me a...
  5. G

    Union all and group by

    4 tables with too many fields. Second query I already have but not working with my form. I need in my form where I choose name select field where are money. Dlookup doesn't work whit it. 🤔
  6. G

    Union all and group by

    Hello, according to the pictures, I have tables grouped by name and totaled amounts. But now I need to group it and add it all up. So that the query contains only the name once and the sums added together. And if I don't see zero values there, I'll be happy :)
See more
Top Bottom