Go Back   Velocity Reviews > Newsgroups > Microsoft Certification
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

Microsoft Certification - access query for unique value

 
Thread Tools Search this Thread
Old 02-12-2008, 07:02 PM   #1
Default access query for unique value


need to see unique value for 1 column but have a second column I want to just
display. for example:

col 1 col 2
abc 123
abc 234
ddd 654
ddd 655
ddd 657

want to see either of abc with either 123 or 234 displayed
want to see ddd with either 654, 655 or 657


CHARI
  Reply With Quote
Old 02-12-2008, 08:12 PM   #2
Mostly Gizzards
 
Posts: n/a
Default Re: access query for unique value
"CHARI" <> wrote in message
news:6C134A33-A14F-48AA-A37D-...
> need to see unique value for 1 column but have a second column I want to
> just
> display. for example:
>
> col 1 col 2
> abc 123
> abc 234
> ddd 654
> ddd 655
> ddd 657
>
> want to see either of abc with either 123 or 234 displayed
> want to see ddd with either 654, 655 or 657


Probably ought to try posting in the Access newsgroups instead of
certification.

MG



Mostly Gizzards
  Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
I cant access the MCP site T3M4N MCTS 1 03-18-2008 06:21 PM
Pix 515E Access List issue ally0000 Hardware 3 02-15-2008 01:34 PM
Pix 515E Access ist issue ally0000 Hardware 0 01-12-2008 10:09 AM
Cannot access one URL Elke General Help Related Topics 1 12-02-2006 11:36 AM
Problem accessing query in the design mode MS access shieldguy Software 0 11-07-2006 02:45 PM




SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46