New call-to-action
Results 1 to 3 of 3

Thread: selecting records in a report

  1. #1
    Al Kadin
    Guest

    Default selecting records in a report

    I've developed a report based on a Table. Each record contains the date entered. The database contains records going back several months. I want to select only those records in a specific (Variable) month to include in the report.
    I Know how to do it by selecting the Filter Expression Window and the Filter Builder window.
    My question is:
    Is it possible to automate the record selection procedure so that when I Push the Report Button a "Query" window opens for inputting the Month for those records wanted? That seems the proper way to do it for the User. I know it can be done in Access easily.
    Thanks Al kadin

  2. #2
    Member
    Real Name
    Colin Roberts
    Join Date
    Feb 2003
    Posts
    287

    Default RE: selecting records in a report

    Check out BETWEEN() and ASK variables.

    The following thread goes into some discussion, which you may find useful

    http://msgboard.alphasoftware.com/alphaphorum/read.php3?sortby=lastreply&direction=desc&num=11&id=69890&thread=69803

    I'm sure this subject has been raised many times before so try running some searches.

  3. #3
    Al Kadin
    Guest

    Default RE: selecting records in a report

    Thanks for the info. The between expresion works just fine however I noted the Genie has a condition where it asks for the month (which is part of the Date field). That also works but I cannot get it to request Mointh value as the criteria before the report is run. Any ideas as to what the expression should be?

    Al

Similar Threads

  1. Selecting records for a report
    By Stephen Tierney in forum Alpha Five Version 6
    Replies: 2
    Last Post: 09-12-2005, 07:16 AM
  2. selecting records
    By Ernest Paushter in forum Alpha Five Version 5
    Replies: 1
    Last Post: 02-13-2003, 06:55 AM
  3. selecting records in report
    By Frank Ryan in forum Alpha Five Version 5
    Replies: 1
    Last Post: 10-22-2002, 07:49 AM
  4. Selecting records for report header
    By Larry Ternowski in forum Alpha Five Version 4
    Replies: 1
    Last Post: 10-09-2002, 04:18 PM
  5. Selecting records for Print
    By Rick Hamilton in forum Alpha Five Version 4
    Replies: 3
    Last Post: 06-23-2002, 09:55 AM

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
  •