Bi-monthly totalling query

[Joy]

I'm trying to make a query that totals bi-monthly rather then monthly, can't
quite get it, actually don't know if possible. Any help would be greatly
appreciated.
This is want I'm playing with

SELECT [ReceiptDetailsZone Query].[CDate By Month], [ReceiptDetailsZone
Query].[Sum Of Fee], [ReceiptDetailsZone Query].[Count Of ReceiptDetails],
[ReceiptDetailsZoneFindout Query].[CDate By Month],
[ReceiptDetailsZoneFindout Query].[Count Of FindOut],
Format$([ReceiptDetailsZone Query.CDate By Month],'mmm ') AS [Month]
FROM [ReceiptDetailsZone Query] INNER JOIN [ReceiptDetailsZoneFindout Query]
ON [ReceiptDetailsZone Query].[CDate By Month] = [ReceiptDetailsZoneFindout
Query].[CDate By Month];

 

[Joy]

--
Many thanks

I'm trying to make a query that totals bi-monthly rather then monthly, can't
quite get it, actually don't know if possible. Any help would be greatly
appreciated.
This is want I'm playing with

SELECT DISTINCTROW Format$([ReceiptDetails].[CDate],'mmm yyyy') AS [CDate
By Month], Sum(ReceiptDetails.Fee) AS [Sum Of Fee], Count(*) AS [Count Of
ReceiptDetails]
FROM ReceiptDetails
WHERE (((ReceiptDetails.CDate) Between [Forms]![OpeningPage]![List21] And
[Forms]![OpeningPage]![EndDate]))
GROUP BY Format$([ReceiptDetails].[CDate],'mmm yyyy'),
Year([ReceiptDetails].[CDate])*12+DatePart('m',[ReceiptDetails].[CDate])-1;

 

[Joy]

Sorry the first query was the incorrect one
--
Many thanks

I'm trying to make a query that totals bi-monthly rather then monthly, can't
quite get it, actually don't know if possible. Any help would be greatly
appreciated.
This is want I'm playing with

SELECT DISTINCTROW Format$([ReceiptDetails].[CDate],'mmm yyyy') AS [CDate
By Month], Sum(ReceiptDetails.Fee) AS [Sum Of Fee], Count(*) AS [Count Of
ReceiptDetails]
FROM ReceiptDetails
WHERE (((ReceiptDetails.CDate) Between [Forms]![OpeningPage]![List21] And
[Forms]![OpeningPage]![EndDate]))
GROUP BY Format$([ReceiptDetails].[CDate],'mmm yyyy'),
Year([ReceiptDetails].[CDate])*12+DatePart('m',[ReceiptDetails].[CDate])-1;