ACCESS FEED: RE: [MS_AccessPros] Distinct Values

Rabu, 28 Desember 2011

RE: [MS_AccessPros] Distinct Values

John-

Do you have a table that lists boxes? Use that as your Row Source. I suspect
the form is editing Items, so you're probably trying to set the box ID for the
current item. Use a list from the Boxes table.

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: Wednesday, December 28, 2011 9:50 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Distinct Values

There can be several items in a box.

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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
>

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

Yahoo! Groups Links