Need help in reports. Newbie

[JoeAcess]

hello Everyone, I am new to this place. I have been using access only for the last 3 months. i guess this is the place for all my Access doubts.

I am making a monthly report for salary deduction.

1) how do i get it to display a particular months report
2) I would like the report to be sorted by the empno.
3) after sorting i want want the total for each employee , because there might more than one deduction for an employee and the overall total at the end


for eg the report should like this

date empno deduction

01/12/2008 52131 50.00
03/12/2008 52131 75.00
---------
125.00

01/12/2008 61124 12.00
05/12/2008 61124 100.00
----------
112.00

---------------
237.00

 

[dkinley]

Welcome to the forums!

Just FYI .... This could get very hairy in order to convey the correct process needed to obtain your goals since you are pretty new to Access.

The following links should help you overcome your issues and get you better familiarized with Access and expedite your learning curve.

http://www.techonthenet.com/access/index.php
http://www.sienaheights.edu/personal/csstrain/Access2007.htm
http://www.functionx.com/vbaccess/

Take a look through these to see if they can help resolve your issue. If not, please post back.

Hope they helps,
-dK

 

[JoeAcess]

Thank you Dk.. I am going through the link. Seems to workl.. I haven't finished completely going through the links but its really helpful.

thanks

 

[dkinley]

Great! The only reason I suggested it was because you had 1 request with 3 requirements attached to it. With better familiarization you will then have the capability to explain where you are specifically struggling.

What you are asking for is not difficult for people versed in Access, but we could spend many posts requesting information from you and attempting to explain what you should do. Once you get into those links and a better comfort zone with Access, this sort of thing could be resolved in a couple of posts.

Good luck and if you are stumped over something in the links or you just can't get over that last hurdle - by all means post back.

-dK