Hello everyone!!!!!

I would be soooo happy if somebody could help me!

I have to do a database of the employees in a company. It has been ok
so far but now I'm in the big trouble. I have to make the database of
the payments of their wages. I would be very very very happy if
somebody could help me! I don't understand how to do this?

Maybe you would understand my problem if I explain what I would like
to do. I have counted the monthly pay in a normal query for all the
employees - It comes from the basic pay and then depending on how many
years they have worked etc. But how can I make the application to sum
up this monthly pay automatically - 15th of every month - to another
table???!! And what if the wage changes where does the payroll clerk
input the changes of the monthly pay? Do I have to make a form for
that or how does it work?


Somebody told me to use this group by / sum up - action. But what do I
really sum up because I have the monthly payment just once in a query?

I have no idea how to do this!! Many many many hugs for the one who
has the patient to help me!!!

PS I have tried Append, Make a table and Update query also but - yes
I have no idea how do I get it to work!!!

Johanna

FinnishGirl10 (AT) yahoo (DOT) com (FinnishGirl) wrote:

Johanna,

You need to look up "totals ... queries" in the Access help, and also
functions like "DateDiff" and "Format" so that you can work with the month
element of the dates to extract the 15th of "last" month to the 15th of
"this".

Regards,
Keith.
www.keithwilby.org.uk