Results 1 to 3 of 3
  1. #1
    HM1 is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2009
    Posts
    1

    Report Filtering

    Hi



    I have an unbound text box on a report that is performing a numerical calculation based on a couple of bound textbox's. The problem I have is I need to filter the report by the unbound text box, and i just can’t get it to work.

    If I use for example the following in the Filter box of the report properties this works ok. (SumOfTotalSTKValue is a bound value)

    SumOfTotalSTKValue > 100000

    However if I use the same method for the unbound textbox

    TextBoxValue > xx

    it dosnt work, I receive a parameter box asking for a value.

    FYI: The reason I am using the report for the filter rather than the bound query is because the data is derived from a running sum which I am doing within the report. If I do the running sum in the query is slows down tremendously.

    Any ideas/help would be much appreciated.

  2. #2
    ansentry's Avatar
    ansentry is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    May 2009
    Location
    Melbourne, Australia
    Posts
    67
    If I use for example the following in the Filter box of the report properties this works ok. (SumOfTotalSTKValue is a bound value)
    In most cases you would not save a calculation in a table.

    it dosnt work, I receive a parameter box asking for a value.
    As the text box is unbound as soon as you close the form to preview or print the report it empties. In the code that opens your report enter this line at the end of the code;

    Code:
    Me.Visible = False
    Post back if this has not helped, if it has mark the post as solved.

  3. #3
    kevsparky is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    4
    You need to run the calculation in the query to filter by it. In your query design field enter "RunningSum: [Field1] + [Field2] + [Field3] + [Field4]" without the quotes and then you can filter by it on a report.

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

Similar Threads

  1. Problem filtering a report
    By mrk68 in forum Reports
    Replies: 1
    Last Post: 05-03-2009, 09:31 AM
  2. Filtering recs from query ...
    By rfhall50 in forum Forms
    Replies: 0
    Last Post: 02-18-2009, 09:40 AM
  3. Filtering my report
    By ldarley in forum Reports
    Replies: 1
    Last Post: 09-05-2008, 09:14 AM
  4. Filtering using a Substring Help
    By r_walk76 in forum Forms
    Replies: 2
    Last Post: 01-11-2006, 07:13 AM
  5. Automatic Filtering when Opening form
    By Karyn-2000 in forum Forms
    Replies: 1
    Last Post: 12-03-2005, 09:29 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