Search results

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

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

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, hope someone can help… Want to create a calculated field called 'PreviousN' which will take 10% of the value from the 'UpdatedN' field from previous year (2002) add it to current 'N' to give 'UpdatedN' for current year (2003) etc… Year........PreviousN.....N.........UpdatedN...

I have records I keep year after year. I want to obtain a particular field value from say year 2002 the Update field, and place that value in the PreviousYearValue for subsequent analysis to update records using calculated value....hope I'm making sense (see example table below). Year...

I have a form with 3 drop down boxes and a text box What I want to do is select either one or all three of the drop down boxes and for the text box to update automatically. I can do this by setting up a query and setting criteria for the drop down boxes. When the query is run I am asked to...

Hi I have a combo box on a form displaying different objects. I now wish to display that objects group number in a text box. Both objects and groups are within the same table of database. Can any one resolve what is probably a very simple problem Thank you