Re: MS Access Query

[Gina Whipp]

Bawa,

Hmmm, I *know* it can be done in Access and this being an Access newsgroup
that will most likely be the standard reply. I cross-posted to the Excel
newsgroup so you can get an answer about the possiblity and/or how-to in
Excel.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Bawa" <Ba...@discussions.microsoft.com> wrote in message
news:0E9D56AB-BD98-4EF6...@microsoft.com...
> Hi
> I need help with this:
>
> COnsider this Data:
> Description // SW Version // Asset Tag // Machine Name // Name
> Acrobat Standard// 4 // 12345 // abcde // Steve
> Acrobat Standard// 6 // 12346// abcde // Steve
> Acrobat Standard// 6 // 12346// abcde // Steve
> Acrobat Standard// 9 // 23456 // zxcvb// Dick
> Acrobat Pro // 7 // 65432 // qwert // Dave
> Acrobat Pro// 9 // 54321 // qwert // Dave
> Acrobat Std // 8 //67324 // asdfg // Ryan
>
> I want the output as only the Unique & Highet Vales
> Unique Based on Machine Name
> And Highest SW Version
>
> Output:
> Description // SW Version // Asset Tag // Machine Name // Name
> Acrobat Standard// 6 // 12346// abcde // Steve
> Acrobat Standard// 9 // 23456 // zxcvb// Dick
> Acrobat Pro// 9 // 54321 // qwert // Dave
> Acrobat Std // 8 //67324 // asdfg // Ryan
>
> I have this Data in Excel, what is the best way to get the output?
> I was thinking I can import the data in MS Access and then do a query to
> get
> the desired output, I have Access 2003. Or can this be done in Excel?
>
> Please guide me.
>
> Thanks

[B Lynn B]

Exce pivot table tools could handle this, although keeping the columns in the
same order you have them might be best done with a little bit of VBA code.
The code steps could mostly be recorded with the macro recording utility.

Post back her if you need more.

"Gina Whipp" wrote:

> .
>