Results 1 to 2 of 2
  1. #1
    CalvTs is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014

    Filtering a Report

    I've got this query (its in sql here to simplify)

    SELECT OnHand.PalletSpace, Products.ProductID, OnHand.ProductName, OnHand.OnHand, OnHand.LastTransDate
    FROM Products INNER JOIN (SELECT ProductName, PalletSpace, Sum(Quantity) AS OnHand, Max(TransactionDate) AS LastTransDate FROM ProductTrans GROUP BY ProductName, PalletSpace) AS OnHand ON Products.ProductID = OnHand.ProductName

    WHERE (((OnHand.OnHand)<>0))
    ORDER BY OnHand.PalletSpace;

    This query is for a report. I've created a form called Ps which has a text box called Text10. A button on the text box opens the report.

    My problem is I cant get the text in Text10 to filter my report. I know that on my query I could add [SomeText] in criteria and it would ask me for the text to filter, but, my totals are set as expressions, not groups so that is not possible. Any ideas? Can post screenshots if it will help.


  2. #2
    RuralGuy's Avatar
    RuralGuy is online now Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    8300' in the Colorado Rocky Mountains
    The OpenReport command can filter a report. What is the code you have behind your button and what value do you have in your TextBox?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. Report filtering
    By BRM1 in forum Reports
    Replies: 3
    Last Post: 02-15-2013, 12:23 PM
  2. Filtering a report
    By Jamescdawson in forum Reports
    Replies: 4
    Last Post: 02-10-2012, 05:17 PM
  3. Filtering Report
    By adams.bria in forum Access
    Replies: 1
    Last Post: 02-01-2012, 11:10 AM
  4. Report Filtering
    By rhubarb in forum Reports
    Replies: 4
    Last Post: 10-14-2011, 04:18 PM
  5. Report Filtering
    By HM1 in forum Reports
    Replies: 2
    Last Post: 07-06-2009, 06:06 AM

Tags for this Thread

Posting Permissions

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