Problems with a subform

[Tinkerdog]

Please help I've been struggling with this for a week.
I have a database of sports fixtures and results.
I have a form which shows details of the next fixture and on that form I have a subform which shows previous results.
I wish for this subform to only show the results since the team last won, so if their previous results were WWLWLL, it'd just show the results of the last two results.
If I filter on losses I would get all three losses, not just the last two.
I can sort on the field 'result' which is either won or lost, and then use topvalues=1, however I need the query in date order, so it would only show one entry, as topvalues would take each date as distinct, I can't specify topvalues='number of results since last win', as I don't know what value this would be prior to the query.
So I need to be able to sort into date order and then use topvalues=1 on the result rather than the date.
Am I doing this totally the wrong way, I'm sure it must be easier than I am making it, as it is so inelegant.
I'd be grateful for any help.
Cheers.

 

[Beetle]

I wish for this subform to only show the results since the team last won, so if their previous results were WWLWLL, it'd just show the results of the last two results.

If each record has a Date value along with the Results value then you can just return all records where the Date value is greater than the Date value of the most recent record where Results was equal to W. Example;

Where [DateField] > DMax("[DateField]", "YourTable", "[Results]='W'")

 

[Tinkerdog]

Perfection,

Thanks so much Beetle. You're a star. Works perfectly now.