ACCESS FEED: RE: [MS_AccessPros] Distinct Values

Selasa, 27 Desember 2011

RE: [MS_AccessPros] Distinct Values

John-

If the combo box is bound to a field that matches ItemID, then you have no
choice but to include it. If there are duplicate values for BoxNumber, one has
to wonder why. Why do you have multiple items in the same BoxNumber?

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Lawton, OK)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of yshopper
Sent: Tuesday, December 27, 2011 5:20 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: 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]
>

------------------------------------

Yahoo! Groups Links