How can I pick the 1st & last item & sbubtract the last from 1st?

[Guest]

I have entered my weight twice a week into a table. I want to be able to take
the 1st weight and subtract the last weight from it to get my weight
loss/gain. Can someone help me?

 

[Duane Hookom]

Do you have a table structure and some sample records you would like to
share? You don't have to show us actual weights.

 

[Guest]

Rob, on your table you should have at least two fields defined..."Date1" and
"Weight1". Then add two more field..."Date2" and "Weight2". Now make a form
based on that table and enter infor for the first record, like 12/25/05 and
175, then go to the next record and type in 6/1/05 and 185. Now you have two
records with which to use for comparing your weight change. In design view,
you can add the calculated field on the form itself defined as
"=[Weight2]-[Weight1] for a change. Each week you can enter 2 more weights
and see the growing difference. This is not the most elegant design but it
does address your question.

Destin Richter
(e-mail address removed)

 

[Guest]

Actually, the table is set up to post my blood sugar entries, usually two a
day by date and time but I also have a field to post my weights which I check
and enter twice a week. I have a repost that shows all of this information
and is arranged by datr and then by time. The weight field is empty unless I
have check my weight. In the report I wamt to be able to show how much weight
I have gained or lost, starting with my 1st weight, which is the highest and
ending with the last weight posted, which may be higher or lower than the
previous weight. I want to be able to take the last weight posted and
subtract is from the very 1st weight I entered to show where I am at that
time.

 

[Guest]

A little more info about what I want: At present, I have used the MAX() and
MIN() functions to get my desired results but the problem with this is that
my next weight may be a little more than the last one and I want to use the
last weight so that the total shown is correct as of the last weigh-in. Does
that help you see what I want to do a little better?
Thanks,
ROBFWA

 

[Guest]

Thank you for your reply. Sorry it was not helpful. Perhaps you can read my
replies to the other response I have and get a better picture of what I am
trying to do. The table that this information comes from already has about 70
entries with about 10 weight inputs. To do what you suggested would mean that
I have a new weight field everytime I enter a new weight. That isn't
practical for me. If you have any other ideas, I'd like to know.
Thanks!
--
A basic user who would love to be able to know more

Rob, on your table you should have at least two fields defined..."Date1" and
"Weight1". Then add two more field..."Date2" and "Weight2". Now make a form
based on that table and enter infor for the first record, like 12/25/05 and
175, then go to the next record and type in 6/1/05 and 185. Now you have two
records with which to use for comparing your weight change. In design view,
you can add the calculated field on the form itself defined as
"=[Weight2]-[Weight1] for a change. Each week you can enter 2 more weights
and see the growing difference. This is not the most elegant design but it
does address your question.

Destin Richter
(e-mail address removed)

I have entered my weight twice a week into a table. I want to be able to take
the 1st weight and subtract the last weight from it to get my weight
loss/gain. Can someone help me?

 

[Duane Hookom]

Again:
"Do you have a table structure and some sample records you would like to
share? You don't have to show us actual weights."