Re: select (distinct fieldname) in access ?

From: Tom Ellison (tellison_at_jcdoyle.com)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 12:29:16 -0500

Dear Paulo:

I'm not trying to be funny, but have you tried:

SELECT DISTINCT fieldname
  FROM . . .

As long as there's only one column in your query that would give what
you seem to want. Or is it more complex than that?

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

On Mon, 30 Aug 2004 18:09:32 +0100, "Paulo Nunes"
<nunes.paulo@mail.pt> wrote:

>Hi all
>
>Is it possible to do this in MS Access?
>
>select (distinct fieldname)
>from ...
>
>If not, is there an alternative?
>
>Thanks in advance
>Paulo
>

Relevant Pages

  • Re: Managing duplicates when INSERTing.
    ... is it possible to write an update query to do this ... You can import without a PK, eliminate duplicates, then establish the ... >> Tom Ellison ... >> Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • Re: Subtracting date and time values
    ... computation with the next Date Opened to produce MTBF (Mean Time ... I can provide you with the query to do this. ... >>Tom Ellison ... >>Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • Re: Query Help.. Creating a running Total Field?????
    ... Here's an approximate query: ... ORDER BY ClientCode,, Autonumber ... >> Tom Ellison ... >> Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • Re: How to count record
    ... "Tom Ellison" wrote: ... I built a database with your 2 tables, entered the data, and tested. ... The result of running this query are: ... Microsoft Access MVP (watch out! ...
    (microsoft.public.access.queries)
  • Re: line numbers
    ... then the next time you run this query, the row that was 3 before is ... you cannot use these numbers as a long-term reference ... >>Tom Ellison ... >>Microsoft Access MVP ...
    (microsoft.public.access.queries)