ACCESS FEED: Re: [MS_AccessPros] Distinct Values

Selasa, 27 Desember 2011

Re: [MS_AccessPros] Distinct Values

With no ItemID, the field goes blank, no entries.

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> What happens if you get rid of the item ID?
>
> Duane Hookom
> MS Access MVP
>
>
> To: MS_Access_Professionals@yahoogroups.com
> From: jlinux@...
> Date: Tue, 27 Dec 2011 18:03:54 +0000
> Subject: Re: [MS_AccessPros] Distinct Values
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> The Form shows all Box Numbers, not just the unique ones. So I have box numbers from 1-28 and the drop-down shows 10 box number 1, 8 box number 2, etc. I need the form to show just a single box number 1 and not every instance.
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
>
> >
>
> > Looks good from here. Perhaps you can provide more details about your results.
>
> >
>
> > Duane
>
> >
>
> > To: MS_Access_Professionals@yahoogroups.com
>
> > From: jlinux@
>
> > Date: Tue, 27 Dec 2011 17:14:40 +0000
>
> > Subject: [MS_AccessPros] Distinct Values
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> > I have this Select statement on a form:
>
> >
>
> >
>
> >
>
> > SELECT [tbl_Items].[ItemsID], [tbl_Items].[BoxNumber] FROM tbl_Items ORDER BY [BoxNumber];
>
> >
>
> >
>
> >
>
> > How would I return just the Distinct or Unique values? I selected 'Yes' on Unique Values on the Query property sheet, but that did not work. I also tried this:
>
> >
>
> >
>
> >
>
> > SELECT DISTINCT [tbl_Items].[ItemsID], [tbl_Items].[BoxNumber] FROM tbl_Items ORDER BY [BoxNumber];
>
> >
>
> >
>
> >
>
> > But that didn't work either. Can someone please point me in the right direction?
>
> >
>
> >
>
> >
>
> > Thanks,
>
> >
>
> > John
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> > [Non-text portions of this message have been removed]
>
> >
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>