Solved: Show Only Last 3 Dates in a Report

[Anne Troy]

Golf games.
Once a week.
I want the report to only have columns for the last 3 dates in my records.

How do I do that?
Otherwise, I think I've got the report figured out.

I have a DB that I can send to whoever.

[SJ McAbney]

SELECT TOP 3 MyFields
FROM MyTable
ORDER BY MyDate DESC;

[Anne Troy]

LOL. Looks like SQL?

I don't have a clue...

Here's the file.

Puhleeeeeeeeeze??

[smozgur]

I am not sure that it could be solved by using Crosstab query, Anne. Probably there are better and most common solution for that but I used a temporary table with 3 days and scores for these days and updated this temporary table with VBA by opening the report to be the data source for that report.

Not very good way, but..

Suat

[SJ McAbney]

Only the last three dates overall or the last three dates per player?

[Anne Troy]

Okay! The user (now member JoeLeanza) has got smozgur's file and thinks he can work with that.

Marking solved!