Search results

Namliam/dcx693 You suggested using an instance of same query or write a custom function. I am sorry but am not quite sure how to go about doing...

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

Jack Cowley, Afraid I was not able to resolve the problem and cannot understand why not....problems with the SQL structure perhaps.... I found the info from your reference....I do not understand what "DoCmd.OpenQuery" is doing...(this may be where the problem lies). If I zipped the problem...

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