Re: search fields in query combinations
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 03 Jun 2006 14:09:06 -0600
On Thu, 1 Jun 2006 18:06:01 -0700, Immyz
<Immyz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Im sorry im very new o this would it be possible to guide me through how to
do this
Not easily, since I'm not certain what you've changed between your
database and your question. If your table fields are in fact named as
you posted them ([part no], [attribute name], and [attribute]), then
you can simply copy and paste the SQL string
SELECT mytable.[Part No], mytable.[Attribute] AS [Colour],
mytable1.[Attribute] AS [Size]
FROM mytable INNER JOIN mytable AS mytable1
ON mytable1.[Part No] = mytable.[Part No]
WHERE mytable.[Attribute Name] = "Colour"
AND mytable1.[Attribute Name] = "Size";
into the SQL view of a new Query; create a new query, don't select any
tables, select SQL from the View menu item, and paste this in place of
the word SELECT; that Access puts in automatically.
Edit all occurances of mytable to the actual name of your table (which
of course I do not know).
Alternatively, create a new query by adding your table to the query
design window, twice. Select the Part No field from the first
instance, and the other two fields from both instances. Drag the Part
No field from the first instance to the Part No field on the second.
Put a criterion "Colour" under the first [Attribute Name] field, and
"Size" under the second.
John W. Vinson[MVP]
.
- References:
- Re: search fields in query combinations
- From: John W. Vinson/MVP
- Re: search fields in query combinations
- Prev by Date: Re: Formuli in query
- Next by Date: Re: salary
- Previous by thread: Re: search fields in query combinations
- Next by thread: Pivot query
- Index(es):
Relevant Pages
|
