Thanks, Jim. Appreciate your continued patience.
Here is the SQL view of the query that produces the result set I'm trying to reorder with the query we're working on here:
SELECT [tblItemsAndAuth ors].[ItemID], LTrim([tblAuthorsEtc.L astNameNonSort] & " " & [tblAuthorsEtc.L astName]) AS FullLastName, [tblItemsAndAuth ors].[Weighting]
FROM tblAuthorsEtc INNER JOIN tblItemsAndAuth ors ON [tblAuthorsEtc].[AuthorID]=[tblItemsAndAuth ors].[AuthorID]...
FiveFootUnder
Last Activity: Sep 10 '07, 08:32 AM
Joined: Sep 4 '07
Location:
-
Hi Jim, and thanks.
Have had a go at this, and it's not flying for me at all. Even following the alias you have put on the table with manic faithfulness, all I get is gibberish or error messages.
The three fields I'm dealing with - ItemID, Author and Weighting - all come from a query called qry. I've tried plugging my query name and its alias into your SQL, but as I said, without success. So, just to recap, this is...Leave a comment:
-
'Pivoting' without aggregating - is this possible?
Hi. Ow. I have a bruised forehead from banging my head against a brick wall and would really appreciate some help here. As long as it's not a suggestion that I shouldn't be trying this!!
I'm working in Access 2000. I have a recordset resulting from a query consisting of three columns:
ItemID (numeric)
Author (text)
Weighting (numeric: 1, 2, 3 etc - unique values)
Some Items have several authors...
No activity results to display
Leave a comment: