PC Review


Reply
Thread Tools Rate Thread

Re: filtering a query for charts in a form

 
 
pat67
Guest
Posts: n/a
 
      17th May 2011
On May 17, 11:59*am, John Spencer <(E-Mail Removed)> 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<(E-Mail Removed)> *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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: filtering a query for charts in a form pat67 Microsoft Access Queries 0 17th May 2011 10:01 PM
Re: filtering a query for charts in a form pat67 Microsoft Access Queries 0 17th May 2011 08:33 PM
Re: filtering a query for charts in a form John Spencer Microsoft Access Queries 0 17th May 2011 08:21 PM
filtering a query for charts in a form pat67 Microsoft Access Queries 3 17th May 2011 04:59 PM
filtering charts in a form pat67 Microsoft Access Forms 0 14th May 2011 07:08 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:23 AM.