Calculations on First and Last Row

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

Cheryl

Access 2000 and MS Office 2000

qryFirstRow finds the first row and qryLastRow finds the
last row. I need to perform calculations such as
calculating amounts and time between first and last date.
when I create a new query based on qryFirstRow and
qryLastRow and join by the customer name I get the correct
number of rows, but it duplicates the qryFirstRow info
where the info for qryLastRow should be. How do I get
around this.
 
Back
Top