Hello Wayne,
Access is very good for databasing.
However, the methods of providing
data and calculations vary, depending
on the style of the database.
In Access your calculations can either be provided
in report format or in real time on a form. But
both require programming a query.
So providing you with a simplified method for your
question in Access cannot be addressed over these
postings.
However, I can provide some guidance
with the formulations.
Keep in mind that only an expert can build
a complex formula having a multitude of variables to
produce a single result.
But the power of the software can allow a regular
person to use many simple formulas in symphony
to produce the same results as well.
My first suggest is that you practice these
formulations in Excel. Once you perfected the
formulas, then you will have a firm idea as to how
to use them program your Access Database.
Using Excel is only a suggestion but highly recommended
before importing the formulations into Access. You see
Access is only a data generator that can produce results
from your formulas. But Excel is a calculator that will
help you test your formulas with generating data.
But the suggestions below can be applied in either program..
Basically, it appears to me that you are
ascertain the relationship of the players varying age
to an age standard/limits. Therefore,
The First Formula should be the difference
between the current date and the players age.
In excel, one cell = birth date,
another cell = current date,
the third cell is the formula/result that
obtains the difference of the 2 cells.
The fourth cells should be defaulted with
the age requirement for baseball or softball.
I suggest to simply input the number 10 in all
of them for this exercise. Later you can modify
this variable.
The Second Formula is where you can get the computer
to do a little thinking for you.
The fifth cells should be an "if" statement based
on these variables:
If cell 3 is greater that cell 4, then state "baseball",
if cell 3 is less than cell 4, then state "softball".
There may be a deviation with my interpretation
of the information you provided. However
as with any calculation there is always more than
one formula to obtain a result. But the above
should give you an idea.
It is because of the power that
both Access and Excel provide
to you, you will have the flexibility to
fine tune your calculations.
As mentioned before you should use
Excel to experiment with the formulations,
keeping in mind that Access can import or
link your to Excel data.....
db
I am trying to enter a formula for a data base for a Little League. I want
to calculate a Little League age. I want to work with 3 fields ( Date of
Birth, LL age, Baseball or Softball) In the Baseball or Softball field the
entry will be "b or s". Little League calculates the ages differntly base on
baseball or softball. Here is what I would like it to do.
Take year 2007 and got to field "baseball or softball" if it is a "b" then
use 4/30/2007 and calculate the childs age. Example if a child was born on
4/30/1997 his LL age is 10 however today he is actually 9. I want to display
the LL age.
If a softball player is to be caculated then it will be the child age as of
12/31/2006 for the 2007 season
