Results 1 to 7 of 7
  1. #1
    aamer is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Location
    Pakistan
    Posts
    240

    Start Date Query Help

    I want to change [Forms]![COPBD]![cboDateFrom] to use the start date in the query.





    POPBal: Sum(IIf([Purchase Date] Between [Forms]![COPBD]![cboDateFrom] And [Forms]![COPBD]![cboDateTo],(([Purchase Price]*[Purchase Qty]))-[Payment Made],0))

    Temporarily I am using the following.

    POPBal: Sum(IIf([Purchase Date] Between #1/1/1900# And [Forms]![COPBD]![cboDateTo],(([Purchase Price]*[Purchase Qty])),0))


    What is the exact way to write this.

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,493
    What happens when you use this expression. It appears that it is set up properly.


    POPBal: Sum(IIf([Purchase Date] Between [Forms]![COPBD]![cboDateFrom] And [Forms]![COPBD]![cboDateTo],(([Purchase Price]*[Purchase Qty]))-[Payment Made],0))

  3. #3
    aamer is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Location
    Pakistan
    Posts
    240
    it works perfect.
    But in this case I have to input the start date where as I want the system should pick up whatever the start date (CboDateFrom) is in the data and I input the last date (CboDateTo)

  4. #4
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,493
    Your answer confuses me. Perhaps you should post a sample database with your sample data so that we can understand it better.

  5. #5
    aamer is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Location
    Pakistan
    Posts
    240
    Sorry for the late reply.

    Sample DB OB-001A is posted for better understanding. Please also check where am I making a mistake that the wrong Running Balance on the report is being generated.
    The opening balance is added to every transaction. How can I fix this.

    Please Run the Report from Form "COPBD" Select Account Title: "AK Transport" Select Start Date: 01/01/2014 Select End Date: 03/08/2014 To Generate the Report Attached.

    Sample DB OB-001A: OB-001A.zip



    Click image for larger version. 

Name:	PBCoReport.jpg 
Views:	13 
Size:	166.4 KB 
ID:	24027

  6. #6
    aamer is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Location
    Pakistan
    Posts
    240

    Start Date Query & Opening Balance On Report Help Needed

    Help needed

  7. #7
    aamer is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Location
    Pakistan
    Posts
    240
    Very Strange, seems like nobody knows how to fix this problem

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 11-20-2018, 11:57 PM
  2. Replies: 6
    Last Post: 03-02-2016, 12:58 PM
  3. Replies: 3
    Last Post: 12-06-2014, 03:59 AM
  4. call specific start date in crosstab query
    By tngirl in forum Queries
    Replies: 4
    Last Post: 03-11-2014, 07:20 AM
  5. Start & End Date Query
    By batowl in forum Queries
    Replies: 1
    Last Post: 05-16-2011, 09:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums