YeuEmMaiMai
Regular
I am trying to get access to return a result of the top 5 items in each market and I am having issues.... (I am not too bright in MS ACCESS ) and I have tried looking on the web but my search by words of Top 5 by category returned some bizzare results.
example of what I want to do.
MARKET.ITEM.....# SOLD
east.......widget... 500
.............midget.. 400
west.......lidget.... 300
North
etc....
I tried using the top value but it only returns the top 5 in the first market and stops there
anyone got any ideas?
example of what I want to do.
MARKET.ITEM.....# SOLD
east.......widget... 500
.............midget.. 400
west.......lidget.... 300
North
etc....
I tried using the top value but it only returns the top 5 in the first market and stops there
anyone got any ideas?