Results 1 to 2 of 2

Thread: Blank Report

  1. #1
    Join Date
    Jul 2006
    Posts
    157

    Unanswered: Blank Report

    Hi: Is it possible that if i leave the CRC or date blank in my form (frmweb_Mailfilter) it will show all of the record. As right now if i am not select any value from the form it shows the blank report.


    SELECT tbl_WebMail.CRC, Sum(tbl_WebMail.WM_Amt) AS Totamnt
    FROM tbl_WebMail
    WHERE (((tbl_WebMail.WM_Date) Between [Forms]![frmWeb_Mailfilter]![txtdate1] And [Forms]![frmWeb_Mailfilter]![txtdate2]))
    GROUP BY tbl_WebMail.CRC
    HAVING (((tbl_WebMail.CRC)=[Forms]![frmWeb_Mailfilter]![ddlcrc]));

    Thanks.

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372

    Hello mustish!

    Look at "DemoAllRecA2000.mdb", I think it is what you need.
    Look Table1, Query1, Form2SelectDate, especealy DEFAULT VALUE for
    Date from and Date to fields.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •