We have a database set up in access where we keep all of
our employee information (hire date, address, SS, etc.).  We also use the
spreadsheet for one of our steps in doing payroll.  The way we have it set
up, we click on the "+" sign next to the employee to add payroll 
information under that employee.  When an employee receives a pay increase 
we build another line showing the old rate and the new rate, we do not 
delete the information until the next year.

When I run queries for different things I will set it up to give me the
information I want, but if some of our employees have had 3 different pay
rates during the year, it will list their name that many times on my
spreadsheet.  In the past I have always imported the spreadsheet into excel
and deleted the duplicated information.  My question for you is, do you 
know
if there is a way to set up a query so that it will only show the
information in my main spreadsheet, not the information under the "+" sign?

I hope this makes enough sense for you to possibly answer my question, any
information you can provide me will be much appreciated.

Thank you!  

Jamie Kriegel

Hi there,

You have confused me a little, referring to spreadsheets being imported 
into Excel - I think you mean a table, or query result.

You should be able to resolve the issue by using a sum select query, and 
grouping by Employee name, or number, and then "max" of the date of 
change field.  This way you will simply get the lastest pay rates.

Need more help, send me the database (or sample data), and I will do the 
query for you.

Regards

Gary
> We have a database set up in access where we keep all of
o> ur employee information (hire date, address, SS, etc.).  We also use 
the
s> preadsheet for one of our steps in doing payroll.  The way we have it 
set
u> p, we click on the "+" sign next to the employee to add payroll 
i> nformation under that employee.  When an employee receives a pay 
increase 
w> e build another line showing the old rate and the new rate, we do not 
d> elete the information until the next year.

> When I run queries for different things I will set it up to give me the
i> nformation I want, but if some of our employees have had 3 different 
pay
r> ates during the year, it will list their name that many times on my
s> preadsheet.  In the past I have always imported the spreadsheet into 
excel
a> nd deleted the duplicated information.  My question for you is, do you 
k> now
i> f there is a way to set up a query so that it will only show the
i> nformation in my main spreadsheet, not the information under the "+" 
sign?

> I hope this makes enough sense for you to possibly answer my question, 
any
i> nformation you can provide me will be much appreciated.

> Thank you!  

> Jamie Kriegel

Thanks Gary,

Let me give it a whirl and I'll let you know what becomes of it.  Thanks for
your help.

Jamie

-----Original Message-----
From: gburke4@b... [mailto:gburke4@b...]
Sent: Sunday, January 26, 2003 12:33 AM
To: Access
Subject: [access] Re: Need Query Help Please!


Hi there,

You have confused me a little, referring to spreadsheets being imported
into Excel - I think you mean a table, or query result.

You should be able to resolve the issue by using a sum select query, and
grouping by Employee name, or number, and then "max" of the date of
change field.  This way you will simply get the lastest pay rates.

Need more help, send me the database (or sample data), and I will do the
query for you.

Regards

Gary
> We have a database set up in access where we keep all of
o> ur employee information (hire date, address, SS, etc.).  We also use
the
s> preadsheet for one of our steps in doing payroll.  The way we have it
set
u> p, we click on the "+" sign next to the employee to add payroll
i> nformation under that employee.  When an employee receives a pay
increase
w> e build another line showing the old rate and the new rate, we do not
d> elete the information until the next year.

> When I run queries for different things I will set it up to give me the
i> nformation I want, but if some of our employees have had 3 different
pay
r> ates during the year, it will list their name that many times on my
s> preadsheet.  In the past I have always imported the spreadsheet into
excel
a> nd deleted the duplicated information.  My question for you is, do you
k> now
i> f there is a way to set up a query so that it will only show the
i> nformation in my main spreadsheet, not the information under the "+"
sign?

> I hope this makes enough sense for you to possibly answer my question,
any
i> nformation you can provide me will be much appreciated.

> Thank you!

> Jamie Kriegel