working with queries

Thanks for the help in my past posts.

Here I go again.

This is what I need to do. I need to look at a certain cell in the first
record of a set I queried for. I need to compare this cell with a different
cell, in the last record of this set. I want to see both of these cells from
within a report, and I want to subtract the 1st cell from the 2nd, arriving
at an answer which will also show on report.


Another question I have is there a way to autofill a cell in a record with
info from the previous record? Like in EXCEL where you can, in cell B2:
"=A1" and whatever you put in A1 automatically is entered into B2.

Any help will be appreciated.

Rick

Access doesn't have "cells" (no matter what they look like.

If you have a query, the rows it returns are NOT in any particular order
unless YOU specific how they are to be sorted.

If you have two different values (in two different rows), what is it about
the records those rows represent that makes it make sense to compare the
two. I'm not asking out of simple curiosity, but to better understand WHY
this needs to happen. For example, if I took a series of measurements on an
item, over time, and wanted to compare the "final" measurement with the
"first" measurement, I would do that by using a combination of queries.

More specific description may lead to more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"sparky" (spamfree) wrote in message
...
Thanks for the help in my past posts.

Here I go again.

This is what I need to do. I need to look at a certain cell in the first
record of a set I queried for. I need to compare this cell with a
different
cell, in the last record of this set. I want to see both of these cells
from
within a report, and I want to subtract the 1st cell from the 2nd,
arriving
at an answer which will also show on report.


Another question I have is there a way to autofill a cell in a record with
info from the previous record? Like in EXCEL where you can, in cell B2:
"=A1" and whatever you put in A1 automatically is entered into B2.

Any help will be appreciated.

Rick