Filtering a Report

[smeagain]

I have a table that shows payments made by different people on different dates. Each month the same people make new payments. I want to be able to filter my report to show only the latest payment made by one particular person at a time. At the moment it is showing all of the payments made by each particular person.

 

[Mr. B]

Base your report on a query, not the table.

Design your query so that it returns only the data you need or want.

You can then group your report on the person field so you see each record for each person.

 

[smeagain]

HI, thank you for your response, but I have never created a query so I do not know where to start

 

[vbaInet]

www.functionx.com is a good start and the only way to learn is by doing it yourself.

Don't forget the Access Help Files too.

 

[Mr. B]

Ok, first, you have not mentioned which version of Access you are using. The basics of using Access are the same for all versions but how to navigate to the functionality you need will vary based on the version.

I would offer a couple of suggestion; first, Google is about to become your best friend. For example, if you type in "MS Access create a query" and search Google you will get a lot of help.

Second, search here in these forums. You will be amazed what has already been answered.

With all that said, I do understand that if you are reallly new to Access (and it sounds like you are) then it can be overwhelming. Some of the terminology may not be clear and unstandable. So, when you cannot find the help you need using the frist two suggestions, don't be afraid to ask your questions here. There are no dumb questions.

Here are a couple of links that might help:

http://support.microsoft.com/kb/304361

http://databases.about.com/od/tutorials/l/aaquery1.htm

http://office.tizag.com/accessTutorial/accessqueries.php

http://office.microsoft.com/en-us/a...part-iii-writing-the-queries-HA010247313.aspx

I hope these help.

Please check your private messages.