If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
DISTINCT
I need to pull back a few field from a table. I need one of these fields to
be DISTINCT, at the moment Access is looking at the full record as DISTINCT not just the one field that I want. What am I doing wrong?? |
#2
|
|||
|
|||
DISTINCT
I'm not sure you can do what you're trying to do. Can you post some sample
data, firstly what you are currently getting back, and then what you would expect to get back. Also post the SELECT statement that returns the data. Jon. "Darren" wrote: I need to pull back a few field from a table. I need one of these fields to be DISTINCT, at the moment Access is looking at the full record as DISTINCT not just the one field that I want. What am I doing wrong?? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
DISTINCT vs GROUPBY ? | Stef | Running & Setting Up Queries | 5 | September 13th, 2005 01:58 PM |
memo field distinct rows | Jivko T | General Discussion | 1 | June 2nd, 2005 03:27 PM |
Newbie: Distinct values | steve | Running & Setting Up Queries | 3 | October 28th, 2004 08:35 PM |
A2K Strange Characters in Distinct Query/Form Reference/combo box | david epsom dot com dot au | Running & Setting Up Queries | 0 | September 15th, 2004 10:33 AM |
SELECT DISTINCT | MacDuff | Running & Setting Up Queries | 3 | July 24th, 2004 07:46 PM |