Re: filtering a query for charts in a form

Discussion in 'Microsoft Access Queries' started by pat67, May 17, 2011.

  1. pat67

    pat67 Guest

    On May 17, 11:59 am, John Spencer <> wrote:
    > If you leave out the where line, do you get data?
    >
    > If so, check that Vendor Code is a valid field and has the type of data  that
    > the bound column of cmbVendor is returning.
    >
    > Try extracting the SQL into a query and hand entering the criteria.
    >
    > John Spencer
    > Access MVP 2002-2005, 2007-2010
    > The Hilltop Institute
    > University of Maryland Baltimore County
    >
    > On 5/17/2011 11:20 AM, pat67 wrote:
    >
    >
    >
    > > On May 16, 4:42 pm, John Spencer<>  wrote:
    > >> Try putting in a full reference to the form.

    >
    > >> SELECT qryExc_Mesage_Weekly.[Extraction Date],
    > >> Sum(qryExc_Mesage_Weekly.Cancel) AS [Canx Value]
    > >> FROM qryExc_Mesage_Weekly
    > >> WHERE qryExc_Mesage_Weekly.[Vendor Code]=
    > >> [Forms]![NameOfTheForm]![cmbVendor]
    > >> GROUP BY qryExc_Mesage_Weekly.[Extraction Date];

    >
    > >> John Spencer
    > >> Access MVP 2002-2005, 2007-2010
    > >> The Hilltop Institute
    > >> University of Maryland Baltimore County

    >
    > >> On 5/16/2011 4:29 PM, pat67 wrote:

    >
    > >>> SELECT qryExc_Mesage_Weekly.[Extraction Date],
    > >>> Sum(qryExc_Mesage_Weekly.Cancel) AS [Canx Value]
    > >>> FROM qryExc_Mesage_Weekly
    > >>> WHERE (((qryExc_Mesage_Weekly.[Vendor Code])=[Me].[cmbVendor]))
    > >>> GROUP BY qryExc_Mesage_Weekly.[Extraction Date];- Hide quoted text -

    >
    > >> - Show quoted text -

    >
    > > Ok I tried that and i no longer get a input box, but I also do not get
    > > any data.- Hide quoted text -

    >
    > - Show quoted text -


    yes I get data. If i just put in one code in the where statement, I
    get data for that vendor
     
    pat67, May 17, 2011
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Filtering a query based on results of another query

    Guest, Dec 9, 2005, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    316
    Tom Ellison
    Dec 9, 2005
  2. pat67

    filtering a query for charts in a form

    pat67, May 16, 2011, in forum: Microsoft Access Queries
    Replies:
    3
    Views:
    320
    John Spencer
    May 17, 2011
  3. John Spencer

    Re: filtering a query for charts in a form

    John Spencer, May 17, 2011, in forum: Microsoft Access Queries
    Replies:
    0
    Views:
    284
    John Spencer
    May 17, 2011
  4. pat67

    Re: filtering a query for charts in a form

    pat67, May 17, 2011, in forum: Microsoft Access Queries
    Replies:
    0
    Views:
    300
    pat67
    May 17, 2011
  5. pat67

    Re: filtering a query for charts in a form

    pat67, May 17, 2011, in forum: Microsoft Access Queries
    Replies:
    0
    Views:
    330
    pat67
    May 17, 2011
Loading...

Share This Page