Help on Manipulating Data

  • Thread starter Thread starter Hi
  • Start date Start date
H

Hi

How do I do a SQL query to return (volume at date 10/07/03) - volume at date
(10/06/03) for company a?

date company volume
----------- ---------- --------
10/07/03 a 10
10/07/03 b 8
10/07/03 c 5
10/06/03 a 7
10/06/03 b 9
10/06/03 c 6
 
HI,

Bring the table twice in the query. Join the table through their common
field company, add a criteria for one of the reference to have the date
equal to #10/07/2003#, add a criteria for the other reference so its date is
equal to #10/06/2003#, subtract the volume of the second reference from the
volume of the first reference.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top