Search results
-
Y
Query bassed on criterion
Hi I have a query to get 10 year values. Is it possible to run different queries based on when the sum of the values reaches 100. Is this possible? For example I can have 10 20 20 10 10 10 10 10 0 0 or 0 10 30 30 30 0 0 0 0 0 0 or any other number of combinations. In the first example, it... -
Y
Saving calculated amounts, filtering records and setting criterion for form
Hi everyone! I'm developing a financial projections system and 1 - I have a main form which has command buttons on it that open other forms, each of which have subforms. One form, Approvals, for instance, has 10 subforms in it. I use default value in the mainID (FK) field of each of the... -
Y
Subforms transferring values
Hi everyone Access newbie here. :-) I have a problem in which subforms don't commit records and values get copied to other subforms. I have one main form called Growth which is linked to a 'growth' table, in that form I have 6 subforms connected to a 'finance type' table, in each of those...