Help with Date Query and Report

Hello, hopefully someone can help me. Im trying to pull dates to put in a
count condition report. Ill go into detail as much as possible...

Table:

TblExample
Section Column A Column B Column C Column D Etc
RowA 1 1/10 1/10 1/09 1/15

RowB 1 1/10 1/15 1/11 1/15

RowC 1 1/15 1/12 1/11 1/15

RowD 2 1/11 1/15 1/11 1/11

Etc

Im looking for a way to pull each date and its count into a report:

Report:

Section 1 (Header)

Column A. (header)

1/10 - 2 count
Sub Total 2 Count (via running sum)
1/15 - 1 count
Sub total 3 Count (via running sum)
Grand total 3 Count (Footer) (via overall running sum)

Column B. (Header)

1/10 - 1 count
Sub Total 1 Count (via running sum)
1/12 - 1 count
Sub Total 2 Count (via running sum)
1/15 - 1 count
Sub Total 3 Count (via running sum)
Grand Total 3 Count (Footer) (via overall running sum)

Etc

Section 2
1/11 - 1 Count


Etc

Query:

When I try to make a query to pull this information via dlookup:

SELECT tblExample.Section, tblExample.ColumnA, Count(DLookUp("[ColumnA]","
[tblExample]","[ColumnA]<>null")) AS custLookColumnA
FROM tblExample
GROUP BY tblExample.Section, tblExample.ColumnA
HAVING (((tblExample.Section)=1) AND ((tblExample.ColumnA) Is Not Null))
ORDER BY tblExample.Section, tblExample.ColumnA;

My report works for one column but when I start adding other columns (Column
B, C, D etc) it gives me inaccurate numbers (which i assume is because of the
rows sql outputs? IE. one column will have 5 dates while another will have
let say 3) or is it cause of the way i structured the report? Im still new to
Access am I going about this the wrong way? Any help with this mess would be
greatful.

.

Relevant Pages

  • Re: Help with Date Query and Report
    ... Im looking for a way to pull each date and its count into a report: ... Section 1 (Header) ... Sub Total 2 Count (via running sum) ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • RE: Calculating the Grand Total in the Report
    ... Make sure your text box is in the Report Header or Footer and not a Page ... The Running Sum should NOT be set to overall or over group. ...
    (microsoft.public.access.reports)
  • Re: subtotal group records in Access 2007
    ... Everything is doing what it should...numbers only, in the footer. ... number is not only printed in the report header, ... perhaps you could turn off the Running Sum property for the ...
    (microsoft.public.access.modulesdaovba)
  • Re: Eliminate zero values/pass calculated value to new calc field
    ... In my report, I have a Calculated field that sums Beg.Balance and Deposit Amt, less fee amt and/or check amt. ... But then each successive period Ending Balance is off, because the calc still uses the original Beg.Balance amt. ... If there's too much detail here, you might at least consider using the "Running Sum" feature of an Access Report, though you can't do any calculations using it. ... The Queries listed here form the basis for a Report that lists individual transactions by date, running balance for the date, and ending balance. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Show detail rows in report with or without data using VBA?
    ... Dim DetailRowsMax As Integer ' max number of detail rows in detail section ... Dim TotalItems As Integer ' Total data rows in detail section ... 'Dim BlankRowsNeeded As Integer in "On open" event of report ... The running sum will not work in the footer. ...
    (microsoft.public.access.reports)