Re: Subform calculation issue

Sprowler,
The (ex. name) CreditUsed control is "unbound" to any field, so it will
show the same value on all records.
Since it seems as though your using the CreditUsed value as an element in
a calculation, (or logic decision) you should be able to just add a
CreditUsed field to the same table as the subform is based on... and store
the value. Once "bound"... each record can have it's own CreditUsed.
--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."


"Sprowler" <Sprowler@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:533F9049-3029-4822-B176-C3D2A2DDA3C6@xxxxxxxxxxxxxxxx
I am very close but missing a piece on my database. I am creating a
professional growth database. It has two tables. Employees (basics) and
PG
(courses taken), In the courses taken I have credit hours, credits,
enrichment, and enrichment hours, as well as the course information.

I have a form for entering data information. The tables are linked by the
PG ID. I have added a subform that has all the courses listed that an
employee has taken.

I then added a subform that totaled the credits in a query. I decided to
add fields that show which were used "credits used", "credit hours used",
etc. Then I added a calculated field that subtracted the credits used
from
the sum and leaves a balance. I then added an increment field and a
calculated field that multiplies the increment by $35.

Here's the problem, when I enter the credits used increments, it enters
the
same information for all employees. Should I create a third table called
Credit and link them to the employee by ID? Should I just add these
fields
to the employee table? Any suggestions? It looks good, seems right, but
somehow it is not linked to an employee.

Thank you.


.

Relevant Pages

  • Re: Calculating Vacation Time
    ... one with employee personal information, one with their vacation time. ... I then want to group them by employee. ... debits in whichever sense works best for you. ... debits and credits, grouped by employee, limiting the set using a WHERE ...
    (microsoft.public.access.queries)
  • Re: OT..caesars Indiana may take people to court
    ... You have to wonder about the couple who put in $20 and saw that the credits ... I mean, alert an employee? ... FARMER JOHN ...
    (alt.vacation.las-vegas)
  • Re: OT..caesars Indiana may take people to court
    ... I mean, alert an employee? ... Perhaps my values are out of line, but I am quiet as a mouse if that ... FARMER JOHN ... multiplying say .25 a credit I probably wouldn't notice the extra credits ...
    (alt.vacation.las-vegas)
  • Re: I need a report that will pull only one record
    ... > I have set up a database which keeps track of employees, workshops they ... > taken, credits earned and trainers. ... I can pull reports that show all the ... > specified employee and list all workshops and credits for that employee ...
    (microsoft.public.access.reports)
  • Re: Sanity 1, Right-wing Christian extremists 0
    ... credit to applicants from Christian high schools whose textbooks declare the Bible infallible and reject evolution. ... give credit for courses that don't contain the content they think is appropriate? ... accept transfer credits from inferior institutions. ... are ACE accredited - among a number of other accrediting agecies - so, ...
    (rec.sport.football.college)