Recent content by emus

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...

Yes, because the company imports parts into the country and sells, they don't sell abroad, so a company will only be a buyer or a seller. One thing is, I don't totally understand what you mean by "Conditional Formatting would be better for setting comboboxes enabled/disabled.", and what is the...

The problem with making buyers and sellers into 1 table is that buyers are only buyer and sellers are only sellers (With the exception of ZS Otomotiv). Would it make a difference or do you think I still should merge them into one table? Edit: I understand now what you suggest. I should make a...

I'm sorry, I am doing this for a school project so I don't have much knowledge of MS Access or coding. By "Conditions" do you mean to edit the "Where Condition"? because there is no "Conditions" on top of the macro as far as I can see. Also, I don't know what you mean by the control on the form...

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...

It isn't a normal school project, it is an IB program project and there are no directions or formats to follow. I don't think the table design should be changed, because I everything works perfectly with the current design and my teacher liked everything I have done so far. I will describe the...

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...

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...