L
Luis
I need some help again, please...I have the following
table:
Code Vendor Cost Change Date
h305 Eckerd $213 12/01/04
h305 Walgreens $340 12/01/04
h305 AVC $380 12/01/04
h305 AVC $260 12/05/04
h305 Eckerd $230 12/13/04
h305 Walgreens $245 12/16/04
How can I pull the lowest price at the latest change date
for each vendor...and also how can I get lowest price for
at latest change date among all three vendors...
I have used a simple query for my first question by
setting change date total to max, but it does not work.
It gives me 2 rows for Eckerd, Walgreens, AVC...
For my second question, I tried using a crosstab query,
but it does not work...Can someone please hel me?
Thank you in advance,
Luis
table:
Code Vendor Cost Change Date
h305 Eckerd $213 12/01/04
h305 Walgreens $340 12/01/04
h305 AVC $380 12/01/04
h305 AVC $260 12/05/04
h305 Eckerd $230 12/13/04
h305 Walgreens $245 12/16/04
How can I pull the lowest price at the latest change date
for each vendor...and also how can I get lowest price for
at latest change date among all three vendors...
I have used a simple query for my first question by
setting change date total to max, but it does not work.
It gives me 2 rows for Eckerd, Walgreens, AVC...
For my second question, I tried using a crosstab query,
but it does not work...Can someone please hel me?
Thank you in advance,
Luis