Check boxes to run queries
in [Form]
|
From: Natalie on 28 May 2010 09:25 Hi, I want to use check boxes to choose criteria. I was to return a table for the following data: Invoice number, Customer number country, part number, qty, value etc. There are 5 countries, I want to have a check box for each so we can choose which ones to include, and then click GO. How do I do this? I am new to this. Thanks Natalie
From: Tom van Stiphout on 28 May 2010 10:06 On Fri, 28 May 2010 06:25:01 -0700, Natalie <Natalie(a)discussions.microsoft.com> wrote: I'm not sure I understand. Typically an invoice is for a customer, and that customer has a billing address in some country. Why would you want to select countries? Maybe you only want to include invoice lineitems for work performed in certain countries? More info, please. -Tom. Microsoft Access MVP >Hi, > >I want to use check boxes to choose criteria. I was to return a table for >the following data: > >Invoice number, Customer number country, part number, qty, value etc. > >There are 5 countries, I want to have a check box for each so we can choose >which ones to include, and then click GO. > >How do I do this? I am new to this. > >Thanks > >Natalie
From: Al Campagna on 28 May 2010 10:17 Natalie, Check out Option Groups in Access Help. It allows you to group those 5 check boxes into a group, where only one check box can be selected at a time, and gives each selection a different numeric value. For ex. [optCountry]. The query can then determine that IF optCountry = 1 then it's "USA," or IF optCountry = 4 it's "Canada" etc... BUT... Now that will work... but it's clumsy... in that the query must interpret (using IFs) 5 numeric values to a textual equivalent. What happens when you have 6 countries? 8 countries? Each time you'll have to re-"IF" the query for the added numeric values. I would suggest a combo box instead, (ex. cboCountry) with a Value List of all the countries as the RowSource. Then the query can take the combo value directly in it's SQL statement. Country = Forms!SomeFormName!cboCountry If another country is added... just add it to the combo's Value List, and that's it... nothing else to do. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Natalie" <Natalie(a)discussions.microsoft.com> wrote in message news:D98B5A18-10C2-4687-AAFB-BA7BCAFD8BCB(a)microsoft.com... > Hi, > > I want to use check boxes to choose criteria. I was to return a table for > the following data: > > Invoice number, Customer number country, part number, qty, value etc. > > There are 5 countries, I want to have a check box for each so we can > choose > which ones to include, and then click GO. > > How do I do this? I am new to this. > > Thanks > > Natalie
From: Natalie on 28 May 2010 10:53 Thanks for your reply. This is because we are looking at the international sales for the company on certain products, so I i want the product specialists to be able to choose what data they include from the table. Does this make sense?
From: Natalie on 28 May 2010 11:11
Sorry, I'm not sure I understand. I want them to be able to select multiple countries, all or just one. Not sure how to do the combo box. Thanks Natalie |