Thanks Allen, but I'm actually trying to the get the query to return something that looks like this C.Date By ??? Sum Of Fee Count of ReceiptDetails Jul 15 $200 1 Jul 31 $250 4 -- Thank Heaps "Allen Browne" wrote: Subtract 1 from the month number, and then perform integer division by 2.

I'm trying to make a query that totals bi-monthly rather then monthly, can't quite get it. 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

-- Many thanks "Joy" wrote: 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

Declare the parameters. In query design view, choose Parameters on the Query menu. Access opens a dialog. Enter 2 rows: [Forms]![OpeningPage]![StartDate] Date/Time [Forms]![OpeningPage]![EndDate] Date/Time I have assumed you actually have 2 text boxes you refer to: otherwise the Between operator doesn't make sense. More info: http://allenbrowne.com/ser

Check out this web page of Debra Dalgleish under the subject of dependant lists: http://www.contextures.com/xlDataVal02.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- <tbrogdon@gmail.com