Creating payroll database

[teamde78]

Hello there,



I am trying to create a payroll database that will display total payroll by department for the most recent pay week.

My question is.... How do I sort the data once I have summed the total per department for week.

I currently have it set so that it will show all weeks, but what can I do to further filter the results to include just one week, or the most recent.



You can see I have all the data, I just need to create a query that will only show the most recent.

I tried using MAX and LAST for the date field, and it was still adding all of the pay.



If anyone could help me I would appreciate it.

[June7]

For the 'one week', one way is to calculate a week identifier for each record and apply filter criteria to that constructed field. Another is to use begin and end week dates as parameters.

One possibility for the 'most recent': http://allenbrowne.com/subquery-01.html#TopN

[orange]

What is the link between you and your database and the Finance department?

[teamde78]

Its not a real application. It is for a class. Employee information is held in a separate table