+ Reply to Thread
Results 1 to 3 of 3

Create a recordset for a report

  1. 03-12-2009, 02:16 AM #1
    Reema
    Reema is offline
    Registered User
    Join Date
    02-26-2009
    Location
    India
    MS-Off Ver
    Access
    Posts
    69

    Create a recordset for a report

    Hello,

    I have created a filter for a set of records to update the table using


    Please Login or Register  to view this content.
    I want to run the report on only those records - how do I create a filter that returns the current recordset.
    Last edited by Reema; 03-28-2009 at 12:22 AM.
    Reply With QuoteRegister To Reply
  2. 03-18-2009, 02:45 PM #2
    bhill
    bhill is offline
    Registered User
    Join Date
    03-20-2008
    Location
    Buffalo, NY USA
    Posts
    43

    Re: Create a recordset for a report

    You could add this to the WHERE clause in your query. In SQL it would be phrased as:

    Please Login or Register  to view this content.
    or, in query design view, you would just add this to the criteria of the query under the field you want to filter:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 03-28-2009, 12:20 AM #3
    Reema
    Reema is offline
    Registered User
    Join Date
    02-26-2009
    Location
    India
    MS-Off Ver
    Access
    Posts
    69

    Re: Create a recordset for a report

    Thanks for the solution bhill its working...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1