Recent content by dwatt

Wow...that is great, I am indebted to you Namliam. Looks like I need to turn to queries to solve my problems. Recommend any good books? Thank you also dcx692 and Pat Hartman for your contributions. Regards

Looks like you are building a new table, table1_1 from table1 SELECT Table1.A, Table1.B, Table1.F, Table1_1.A, Table1_1.B, Table1_1.E FROM Table1 INNER JOIN Table1 AS Table1_1 ON Table1.B = Table1_1.B AND Table1.A = (Table1_1.A-1) AND …!!; Will the JOIN query handle this problem..(see example...

I am getting a warning that the expression entered has a function containing the wrong number of arguments G: IsNull(DLookup("E", "Table1", "B = " & Table1.[B] & " AND A = " & Table1.[A] - 1), "") Apologies for being a pain, but I cannot see what the problem is as it now looks so perfectly...

sorry G: IsNull(DLookup("E", "Table1", "B = " [B] & " AND A = " [A] - 1), "")

I would like it to be a calculated field expression in Field G of the query design view window. G: (DLookup("E", "Table1", "B = " [B] & " AND A = " [A] - 1), "") Embarressed...

Created a new field expression PrevE as below and came up with an invalid syntax error. What does the Me keyword signify Have I included all operators.... PrevE = IsNull(DLookup("E", "Table1", "B = " Me.B & " AND A = " Me.A - 1), "") Thank you for your patience.. Regards

1. No. ‘B’ is a unique identifier for the record for that year ‘A’, and this is where the current and previous records come in. (see table below) 2. ‘E’ is a calculated field that multiplies ‘C’ and ‘D’ 3. ‘F’ is determined from autolookup tables 4. ‘G’ is a calculated field that takes 10% of...

In answer to dcx693 Yes, I suppose it is as simple as that , a formula to calculate n from n-1. The problem has been shifting that value into the next field next record…so I guess the question is “am I missing something” to which you may throw back (and hopefully) “you sure are….” I thank you...

Fields B and C are numbers which are automatically filled in. Field A in the current record (say n=1) is dependant on the previous record (n = 0) for fields B and C and so on… (B and C in the previous record are multiplied together and 10% of that value is placed in the next record for A which...

Could be 100's could be 1000's....I would like to keep that open. Cheers

I would rather do in Access if possible as this is the final piece in fulfilling my database requirements....I think.... so help here would be gratefully appreciated. Thanks

Apologies I mean on form I have 2 rows with fieldnames A,B,C

On form I have 2 recordsets with fieldnames A,B,C I want to calculate a new value for A in recordset 2 using B and C in recordset 1: An = (Bn-1 * Cn-1)/10 B....C.....A 10...2....0 15...25..2 'A' will have an initial value of 'o' and B,C are precalculated values. How can I go about...

Thanks for the reply. Afraid I cannot bring these fields together. Is there any other statement I might use like SQL. Have little experience with SQL What I want to do is add up the fields in D with respect to A and B remaining the same and C changing. Only when A or B changes a new record...

Have a problem with using DSum function when two tables are linked together. The tables are linked by the ID field. Tables are Table1 and Table2 with respective fieldnames (ID, A, C, D) and (ID, B). Datatypes are (number, text, number, number) and (Autonumber, number) The following function...