How to print last 3 visit dates in report

[Leen]

Hello,

I have been looking around for quite some time, but I can't seem to find what I am looking for. With 2 experts I have already dealt and I am sure one will find the solution to this one!

My DB (Access 2010) prints out a report from several subforms. As the last information on the report I'd like to print the last 3 (or the most recent 3) visit dates (with some connected info) on the report. This obviously changes when a new visit is booked.

I don't have the foggiest idea even where to start.

Hopefully someone can help me.

Thanks,

Leen

[June7]

Perhaps TOP N query as the subform RecordSource will serve, something like:

SELECT TOP 3 * FROM tablename ORDER BY [date field];

[Leen]

Perhaps TOP N query as the subform RecordSource will serve, something like:

SELECT TOP 3 * FROM tablename ORDER BY [date field];

Hello June7!

Nice to "talk" to you again.

Your response is very appreciated, but I have no clue how to interpret it. I am good in following steps, as I believe are many people.

The Report is almost ready, except for the "last three dates" (visits) with some accompanying info. This info of course changes when a visit is made.

Really, I have been looking far and wide on the internet, including your website, but am at wits' end.
No idea where to start...

So please, help me as you did before so graciously.

Thanks

[orange]

Here is the description of TOP and an example and a test area to test changes in the sql.

[June7]

Suggestion is to use the SQL statement as the subreport RecordSource. Use your table and field names in place of the generic examples I used. The * is wildcard - it will pull all fields. If you don't want all fields, then enumerate them in place of the *.

[Leen]

Suggestion is to use the SQL statement as the subreport RecordSource. Use your table and field names in place of the generic examples I used. The * is wildcard - it will pull all fields. If you don't want all fields, then enumerate them in place of the *.

Could you please give me an example?

[June7]

That is an example. What exactly do you not understand about building a query? Use the query designer. The TOP N is an option in the query properties.

Can build the query directly in the RecordSource property. Click the ellipsis (...) to open the query designer. An Advanced Beginner should already be familiar with this basic Access functionality.