PDA

View Full Version : Solved: Show Only Last 3 Dates in a Report



Anne Troy
08-15-2004, 07:58 AM
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
08-16-2004, 01:29 AM
SELECT TOP 3 MyFields
FROM MyTable
ORDER BY MyDate DESC;

Anne Troy
08-16-2004, 01:44 AM
LOL. Looks like SQL?

I don't have a clue...

Here's the file.

Puhleeeeeeeeeze??

:ipray:

smozgur
08-16-2004, 05:16 AM
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
08-16-2004, 07:31 AM
Only the last three dates overall or the last three dates per player?

Anne Troy
08-16-2004, 03:10 PM
Okay! The user (now member JoeLeanza) has got smozgur's file and thinks he can work with that.

Marking solved!