Mississippi Girl
Board Regular
- Joined
- Oct 27, 2005
- Messages
- 155
I'm joining two queries into one. Both have the field Period, which is a month. On the query results, I'd like to order the period as Oct, Nov, Dec, etc. I've tried the Order By syntax, but that doesn't work. Anyone have any ideas?
Thanks!!!!!!
Thanks!!!!!!
Code:
SELECT [qryContractReviewCost].[Cost Element], [qryContractReviewCost].[Op Plan Description], [qryContractReviewCost].[Project Code], [qryContractReviewCost].[BLI], [qryContractReviewCost].[Period], [qryContractReviewCost].[Sum of Cost] AS [Cost], [qryContractReviewPlan].[SumofPlanned $$] AS [Plan]
FROM [qryContractReviewCost]
LEFT OUTER JOIN [qryContractReviewPlan] ON [qryContractReviewCost].BLI = [qryContractReviewPlan].BLI
AND [qryContractReviewCost].[Cost Element] = [qryContractReviewPlan].[Cost Element]
AND [qryContractReviewCost].[Op Plan Description] = [qryContractReviewPlan].[Op Plan Description]
AND [qryContractReviewCost].[Project Code] = [qryContractReviewPlan].[Project Code]
AND [qryContractReviewCost].Period = [qryContractReviewPlan].Period
UNION SELECT [qryContractReviewPlan].[Cost Element], [qryContractReviewPlan].[Op Plan Description], [qryContractReviewPlan].[Project Code], [qryContractReviewPlan].BLI, [qryContractReviewPlan].Period, [qryContractReviewCost].[Sum of Cost], [qryContractReviewPlan].[SumofPlanned $$]
FROM [qryContractReviewCost]
RIGHT OUTER JOIN [qryContractReviewPlan] ON [qryContractReviewCost].BLI = [qryContractReviewPlan].BLI
AND [qryContractReviewCost].[Cost Element] = [qryContractReviewPlan].[Cost Element]
AND [qryContractReviewCost].[Op Plan Description] = [qryContractReviewPlan].[Op Plan Description]
AND [qryContractReviewCost].[Project Code] = [qryContractReviewPlan].[Project Code]
AND [qryContractReviewCost].Period = [qryContractReviewPlan].Period;