Search results

  1. E

    Help with automatic Poisson Distribution tables

    Hello, For a school project, I am calculating the results of the 2020-2021 EPL season with the results from the 2019-2020 season using Poisson Distribution. The way I do this is, I calculated the mean (λ) for away matches and home matches since they differ. I have made a table as such, but I...
    • emus
    • Thread
    • Replies: 1
    • Forum: Excel
  2. E

    Limit a Macro's usage (kind of)

    So, my database has a table for products, where the product amount is also recorded. There is also a transactions table, that looks like this: In a SALE, it wouldn't make sense for ProductQuantity in the Transactions table to be more then the amount of product in the inventory. To prevent that...
    • emus
    • Thread
    • Replies: 16
    • Forum: Macros
  3. E

    Changing a field's value based on another field.

    This database is for a high school project so it won't actually be used. As a result, I know close to nothing about coding and developed and designed this database from the ground up, so don't crucify me for bad database design. So, the database records transactions of a certain company...
  4. E

    Help with Multi-table query: Which "Producer Code" has been in a transaction the most?

    Hi, before I get into it, I will translate some field names for you. (Üretici Kodu: Producer Code, Stok Adı: Stock Name) I am trying to do a query to display which "Producer Code" has been used the most in the transactions. But the "Producer Codes" aren't in a combo box format because I imported...
Top Bottom