Martin Beney
Registered User.
- Local time
- Today, 21:07
- Joined
- Mar 22, 2007
- Messages
- 27
Hi people,
I am sure I am being massively stupid but I have a problem with a very simple (testing only) query.
The query:
SELECT [Recipes plus category summary].[Recipe ID], [Recipes plus category summary].Expr1
FROM [Recipes plus category summary]
ORDER BY [Recipes plus category summary].[Recipe ID], [Recipes plus category summary].Expr1;
Returns (correctly):
Query2 Query2
But when I add a group by clause to return the FIRST row of this:
SELECT [Recipes plus category summary].[Recipe ID], First([Recipes plus category summary].Expr1) AS FirstOfExpr1
FROM [Recipes plus category summary]
GROUP BY [Recipes plus category summary].[Recipe ID]
ORDER BY [Recipes plus category summary].[Recipe ID], First([Recipes plus category summary].Expr1);
It Returns:
Query2 Query2
Which is blatantly the LAST record.
Please what am I doing wrong?
Regards
Martin
I am sure I am being massively stupid but I have a problem with a very simple (testing only) query.
The query:
SELECT [Recipes plus category summary].[Recipe ID], [Recipes plus category summary].Expr1
FROM [Recipes plus category summary]
ORDER BY [Recipes plus category summary].[Recipe ID], [Recipes plus category summary].Expr1;
Returns (correctly):
Query2 Query2
Recipe ID | Expr1 |
---|---|
68469 | 03 Meal Type||100 |
68469 | 03 Meal Type||49 |
68469 | 03 Meal Type||64 |
68469 | 15 Component||29 |
SELECT [Recipes plus category summary].[Recipe ID], First([Recipes plus category summary].Expr1) AS FirstOfExpr1
FROM [Recipes plus category summary]
GROUP BY [Recipes plus category summary].[Recipe ID]
ORDER BY [Recipes plus category summary].[Recipe ID], First([Recipes plus category summary].Expr1);
It Returns:
Query2 Query2
Recipe ID | FirstOfExpr1 |
---|---|
68469 | 15 Component||29 |
Please what am I doing wrong?
Regards
Martin