Subquery with Field Cell Calculations

  • Thread starter Thread starter Lin
  • Start date Start date
L

Lin

Hi,

I have a query as follow as

Year DATA
1995 1320.85
1996 1485.36
1997 1265.65 ETC.......
i WOULD LIKE TO CALCULATE THE % OF CHANGES USING THE DATA
exapmle: 1485.36/1320.85
1265.65/1485.36 etc.........
Is it possible to create another filed using the field cell data in Access.
I never used subquery before for this kinds of calculation.

Any help, really appreciate.

Thank you
 
Try this --
SELECT Your_Table.Year, Your_Table.Data, Your_Table_1.Year,
Your_Table_1.Data, [Your_Table_1].[Data]/[Your_Table].[Data] AS x
FROM Your_Table, Your_Table AS Your_Table_1
WHERE (((Your_Table_1.Year)=[Your_Table].[Year]+1));

You should not use 'Year' as a field name as it is a reserved word and may
cause problems.
 
Back
Top