Alpha Video Training
Results 1 to 4 of 4

Thread: Query Genie

  1. #1
    Real Name
    Janet Seber
    Join Date
    Sep 2002

    Default Query Genie

    If I have more than three ways that I want to sort information in using the query genie,how do I specify what I want when adding the 4th condition. I do not understand how to use the "is equal to" etc.... For example:if I want the 4th order of the records to be ordered by last name how do I add this using the query genie if I have already used the first 3 orders up."Last name equals" what?.... or "is between" what? Please help me. Thank-you,Janet

  2. #2
    "Certified" Alphaholic
    Real Name
    Ohlen Cartmell
    Join Date
    Apr 2000

    Default RE: Query Genie

    Follow the genie as far as it will allow. One of the final choices is to show you how the genie has filled in the equation without running it. Choose that and then add the additional order condition in the order expression.

  3. #3
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000

    Default RE: Query Genie

    Janet, it looks to me as though the genie is limited to 3 sorting expressions.

    I may be mistaken, but I infer from your message that you think you must specify a sort sequence for each condtion. That's not true I don't believe. The Conditions just define which records will be shown out of all the records in your table or set. The Order expressions are then used to arrange them in the desired sequence.

    -- tom

  4. #4
    john Jones

    Default RE: Query Genie


    When you access the query genie do you get three columns

    Field (ie. State) expression(i.e.equal to) Value(i.e. MA)

    I only get the first two columns no value so I can't run the query?

    Any suggestions?


Similar Threads

  1. Query Genie
    By Doug Chanley in forum Alpha Five Version 6
    Replies: 1
    Last Post: 08-30-2005, 08:34 PM
  2. Query Genie
    By Doug Chanley in forum Alpha Five Version 5
    Replies: 2
    Last Post: 05-26-2004, 12:33 PM
  3. Query Genie
    By Steven Devaney in forum Alpha Five Version 5
    Replies: 5
    Last Post: 02-26-2004, 07:36 PM
  4. Query Genie
    By Steve Hempfliong in forum Alpha Five Version 5
    Replies: 4
    Last Post: 01-27-2003, 11:36 AM
  5. Query Genie
    By Rhea Vaughan in forum Alpha Five Version 4
    Replies: 0
    Last Post: 09-26-2000, 10:12 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