Hello.
Maybe you can help me.
I got a table, that includes a couple of vendors, all selling same items.
I need to get a query that will show me only the last vendor that sold me a specific item.
Using the design grid, I cannot groupby, and give Date as last, since I will get the last date from each vendor. Not only the last vendor with the last date.
Any help??
Tnx in advance.
Eli
Maybe you can help me.
I got a table, that includes a couple of vendors, all selling same items.
I need to get a query that will show me only the last vendor that sold me a specific item.
Using the design grid, I cannot groupby, and give Date as last, since I will get the last date from each vendor. Not only the last vendor with the last date.
Any help??
Tnx in advance.
Eli