Automate procedure

[rohit]

Hello all,

i am having a database of employees where the primary key is a
combination of the month and the employee name. This database contains
the salaries of all employees. i need to perform calculations for each
employee for example i would like to total the salary for each
employee for the past six months and based on the total i need to give
a certain percentage as bonus. i would therefore like to know if there
is a way to automate this process for each employee or if there is an
alternate solution. Hoping for a reply and thanking you all in
advance.

Regards,
Rohit

 

[Bob Quintal]

m:

Hello all,

i am having a database of employees where the primary key is a
combination of the month and the employee name. This database
contains the salaries of all employees. i need to perform
calculations for each employee for example i would like to total
the salary for each employee for the past six months and based on
the total i need to give a certain percentage as bonus. i would
therefore like to know if there is a way to automate this process
for each employee or if there is an alternate solution. Hoping for
a reply and thanking you all in advance.

Regards,
Rohit

As the table grows, youll need the year as well as the month and
employee name.

Use a totals query to get the sum of Salary, group on Employee where
year & month are greater than the year and date 6 months ago.

If you have multiple percentages, build a table with those and hte
salary change points.

Build a second query that takes the first query and the percentage,
and uses a calculated field to do the math.

 

[George]

A similar instance involving duplicate patient names ALMOST happened to my
daughter. She arrived at her appointment, checked in and went to the waiting
room. When the nurse started to review her file, she looked up and said
something to the effect of , "Gee you don't look like you're 24 years old."
My daughter, 14 or 15 at the time, assured the nurse she was not. They
called my wife into the consulting room and quickly sorted it out. Other
than the year in the DOB, the two patients had very similar demographics:
names, month and date of birth, same home town (different addresses of
course).

In other words, no responsible database involving real people would include
names as any part of a key.

 

[Tony Toews [MVP]]

I was present at a clinic where the system used a patient's first name, last
name, date of birth, and gender as the key. On the day in question two
patients turned up for appointments. Both were female, both had the same
first and last names and both had the same date of birth!

My brother has the same birth date, first, middle and last name as a
career criminal. He has a tough time crossing the border into the
USA. Although it seems to be easier lately so I suspect they now have
access to the photo's. Or maybe the other guy has an obvious tattoo.
And as I'm sure you can appreciate our last name is not that common.

Tony

 

[rohit]

Tony:

Can your brother access his alter ego's bank accounts?  Could be profitable,
but there's always the risk of waking up one morning to find a horse's head
on the bed!

Ken Sheridan
Stafford, England

Many, many thanks to everyone for all the advise.

Regards,
Troy

 

[Tony Toews [MVP]]

Can your brother access his alter ego's bank accounts? Could be profitable,
but there's always the risk of waking up one morning to find a horse's head
on the bed!

I suspect most career criminals don't have bank accounts or good
credit histories. Unless you're Bernie Madoff or British MPs, of
course.

Tony