help me plzzzzz... (urgent)

  • Thread starter Thread starter marco
  • Start date Start date
M

marco

I have a dataset of courses. I want to change the daily cost, but I don't
want it to affect the students which have taken the course before the changes.


how can i do it??

I really appreciate your answers. thank you
 
From your description, you need to either record the "cost at registration"
for each student, or you need to have a historical table of courses with
costs. If you use the historical table approach, each cost change results
in a new row. Course costs could have both a BeginDate and an EndDate, and
the "current" cost would have only a BeginDate value.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
 
Jeff said:
From your description, you need to either record the "cost at registration"
for each student, or you need to have a historical table of courses with
costs. If you use the historical table approach, each cost change results
in a new row. Course costs could have both a BeginDate and an EndDate, and
the "current" cost would have only a BeginDate value.
Click to expand...

thank a lot for your help, but I am new in using access 2003. Would you mind
describing what you meant a litttle bit? thank you very mnuch for your help
^^
 
Consider normalizing your data. Data concerning the amount previous students
have paid does not belong in the same table as the courses and the prices
thereof.

Sam
 
marco

As Sam (OfficeDev18) mentioned, it helps to spend the time up front
normalizing your data structure. While Access can handle data that isn't
particularly well-normalized, it and you both have to struggle.

If your data is well-normalized, the features/functions Access offers are
much easier to use.

If "normalized" makes no sense, you may want to spend a bit of time studying
up on it.

As for your request for more details of how, perhaps one of the other
volunteers here can assist. The scope of what you are asking is a ways
beyond what these 'groups usually provide. If you have a more specific
request, you'll probably get a more specific answer.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
 
thank to all..
here are the details:

COURSE (CID, Course_title, period_of_course, cost_per_day, mat_cost,
total_cost)
Stu_course table (name, CID, start, end, bill)

Stu_course QUERY (name, CID, Course_title, start, end, period_of_course,
cost_per_day, mat_cost, total_cost, bill)

how can I change price in course.cost_per_day but it is not changing the
value of the existing data (in stu_course QUERY.cost_per_day)

thank a lot..
 
marco

Please re-read the responses you've gotten. You'll need to decide whether
you record a cost in the Student_Course table (this would leave you free to
change the price on the course, as the cost-at-that-time would have been
recorded), or if you change your Course table to hold historical records of
the course/cost, with begin & end dates (and you'd record the courseID of
the course-at-that-time).

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
thanks to all....

I've finally got the solution. I create new table to store temp value of the
course price.
the code is simple. only 2 lines. ^^
but i've got new prob. here. The code below works in access 2000, but not in
97.. -.-???

a = Forms![Lehrgang Query1].[G_Kosten].Value
Forms![Lehrgang Query1].[Lehrgangsteilnahme_Rechnungen Unterformular].Form.
Price = a

lehrgang [Deutsch] = course [English]
lehrgangteilnahmen rechnungen = student-course

thanks again for all. thank you
 
Back
Top