Rabu, 20 Februari 2013

[MS_AccessPros] Finding the last 3 values in a query

 

Hi

I am trying to do something that seems straightforward but I am struggling to think of a solution and I wondered if anyone can help me out.

2 fields on my sales table are called product and colour (it's just an example so I'm not interested in whether design is right or wrong)

I want a query to list any products whose last 5 sales have been green.

Probably dead easy but I am not seeing it - help please.

Phil

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar