UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> What do I use to specify All?    
 
   
olujimisorinola
post Sep 21 2006, 04:55 AM
Post#1



Posts: 78
Joined: 14-July 06



I have a form containing several textboxes with different expression for calculation purposes.
On the upper left corner of the form, I have two combo box........one for country and one for products. What user chooses in this combo box are used as criteria in my query before the calculations are performed. The combo box get it's data from Tables.......country list and product list respectively.
My problem is this, if I choose a particular country, how can I perform the calculation for all the products.i.e.the data for the whole country is used and not for each product?
please assist?
Go to the top of the page
 
truittb
post Sep 21 2006, 07:02 AM
Post#2


Retired Moderator
Posts: 13,563
Joined: 23-June 02
From: Texas (Is there anywhere else?)


Add an entry to the combobox "-All-"
Then use this method for your WHERE clause in your query

SELECT *
From YourTable
Where (CountryList = Forms!YourForm!YourCountryControl or Forms!YourForm!YourCountryControl = "-All-")
And (ProductsList = Forms!YourForm!YourProductsControl or Forms!YourForm!YourProductsControl = "-All-")
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    17th December 2017 - 03:17 AM