Alpha Video Training
Results 1 to 4 of 4

Thread: Query Genie

  1. #1
    Member
    Real Name
    Janet Seber
    Join Date
    Sep 2002
    Posts
    132

    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
    Posts
    1,599

    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
    Location
    Florida
    Posts
    23,310

    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
    Guest

    Default RE: Query Genie

    Ohlen,

    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?

    Thanks

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

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
  •