Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Okay. Got that last problem solved, but have yet another.

    I am uploading my database to you to see if you can help me on a parameter prompt query I am having problems with.
    I run the qryCustomersByTotalSales and am trying to prompt it for both a year e.g. 2008, and those customers who have a total sales greater than the limit type into the parameter, e.g. 200. However although the year parameter is working, the limit parameter is still showing everyone.

    HELP
    Attached Files Attached Files
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='teachesms' post='769729' date='08-Apr-2009 17:38'][/quote]
    I modify the query qryCustomersByTotalSales

    Is it this you want ?
    [attachment=83265:Assignme...teSports.zip]
    Attached Files Attached Files
    Francois

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='Francois' date='08-Apr-2009 12:10' post='769741']
    [quote name='teachesms' post='769729' date='08-Apr-2009 17:38']
    I modify the query qryCustomersByTotalSales

    Is it this you want ?
    [attachment=83265:Assignme...teSports.zip]


    PERFECT

    BLESS YOU!
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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