Recent content by Rafal

You right.

To my understanding there is no aggregate function in this issue. In Table1 there are just ranges and in Table2 column with figures to which we have find relative score based on Table1 ranges. I'm very happy because all the Sunday I spent to try to solve it by Dlookup which is excellent for...

Thanks, here is proper formula, works good: DLookUp("First([Value1])";"[Table1]";"[Forms]![Form1]![Value2]>=[Min] And [Forms]![Forms1]![Value2]<[Max]"). About update query - still doesn't work. Probably I can't properly address arguments to tables. It is easy to address to forms, but what are...

You right, formula is wrong.

How to find Score corresponding to Value2 in the Table2 based on the ranges Min and Max in Table1 and the corresponding Value1(proper Value1 should land in the Score of Table2)? Below example with a properly filled Score column in the Table2: Table1 Value1 Min Max 4 10 20 7 20 30...

Solution through a relational table: The product table is the parent table, the product name is unique (if not, then ID is unique). One-to-many relationship. In the child table are the producer names associated with the product or product ID. The child table can be placed in the header of the...

You may build pop-up based on the query. In the query there will be criteria in ID column [Forms]![=parent form name]![=name of box in the parent form with ID] and in second column Note. By any command when necessary you are opening pop-up. Query has to be based on the same table as parent form...

You can use split form for the main form - this way you can have main records as datasheet and additionally active record can be seen in heading as a set of preferred size and format boxes. And by command e.g. dbl-click on the cell of datasheet (or in heading) you can open each record as a...

I have been associated with Access since 1994, when Excel and Lotus 123 were no longer able to process the amount of data related to the settlements of the production I was responsible for. My entire professional life is related to the food production and creation, food issues are also my hobby...