How do I create a table using weights as the criteria?

[Guest]

I am finding it hard to find any information in order to calculate and form a
chart using my data for weight loss over each week, there must be a way of
doing it but am unable to find it, please can anyone shed some light?
I want to use stones, pounds and ounces?????
kind regards

 

[John Vinson]

I am finding it hard to find any information in order to calculate and form a
chart using my data for weight loss over each week, there must be a way of
doing it but am unable to find it, please can anyone shed some light?
I want to use stones, pounds and ounces?????
kind regards

Access knows nothing about stones, pounds and ounces - it has Number
datatypes. I'd suggest storing pounds and fractional pounds (e.g. for
me, today I weigh 174.4 lb).

You would create a Table with (at least) two fields - WeighDate, a
Date/Time field, and Weight, a Number field; choose the "Double" type
in the properties of the field at the bottom of the screen. If you
will be tracking the weights of several people (a family, or
weight-watcher's class for example) you'll also need a table of People
with a PersonID as the Primary Key, and a linked PersonID in the table
of weights.

You can use the Chart tool to graph the weight over time - but that's
not what you store in the database; it's just a method of displaying
the data that's stored as numbers.

John W. Vinson[MVP]

 

[Jamie Collins]

If you
will be tracking the weights of several people (a family, or
weight-watcher's class for example) you'll also need a table of People
with a PersonID as the Primary Key

I know names are often duplicated within a family but inventing a
PersonID for them to keep and remember may be taking things to the
extreme. Instead, you should demand they produce their social security
number <g>.

Jamie.

--