Search results

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

No this is only a small part of my database. I thought this was a simple problem that could be easily resolved...aaaHHH I thought I was looking for a query along the lines: If A = year(Date()) Then Bn = Cn-1 Where A = year (Date())-1 Please somebody help. I have little of no query...

Okay your right I am confused too… Field (A) represents a date namely the year…so it’s a number field (its not formatted as a date) A B C 2002 5 8 2003 8 4 2004 4 5 OR A B C 2002 B1 C1 2003 B2 C2 2004 B3 C3 When I work with each year I am only interested in the previous year to...

Hi How would I write a query to answer the following scenaio I have a field (A) with consecutive numbers 10,11,12,.. If I were to select 11 in field (A) I want the value 8 from field (C) in the first recordset where A = 10 to be placed in field (B) of the second recordset where A = 11 A B C...

Hi, I am not a programmer so please forgive me if I appear to be fumbaling... I have attached part of my database(44.7kb zipped). Please goto form FieldDetail... When the program first sets up I want to enter data for the previous year (2002) and therefor be asked for a value for PrevManNAdj...

Hi I am having problems...I have enclosed a copy of the query and form in a zipped doc. Hope makes sense Thank you