Default= ALL

[Mr. SweatyFinger]

Hi, I'm using Microsoft Access, so club me over the head, then read on.

I have a gridview, and a drop down box full of The Names of the United
States (god bless each and every one of them).

The gridview shows a bunch of crap about whatever state was chosen in the
drop down box.

If you are following me, great. Otherwise, get a "idiots for dummies who are
morons" book and get caught up with me.

Now I want to add an ALL STATES option in the drop down box.

Yet what should its value be? An asterisk? A smiley face?

Select * from CRAP_ABOUT _STATES where STATE= *
Select * from CRAP_ABOUT _STATES where STATE= %?%
Select * from CRAP_ABOUT _STATES where STATE= :>)

how do I cause an ALL States to occur?
thanks in advance for your help.
Up yers to the rest of you.

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

RE: Default= ALL

The simplest way is:

Select * from CRAP_ABOUT _STATES

This will return all columns from all rows in the table.

Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net




"Mr. SweatyFinger" wrote:

Hi, I'm using Microsoft Access, so club me over the head, then read on.
>
I have a gridview, and a drop down box full of The Names of the United
States (god bless each and every one of them).
>
The gridview shows a bunch of crap about whatever state was chosen in the
drop down box.
>
If you are following me, great. Otherwise, get a "idiots for dummies who are
morons" book and get caught up with me.
>
Now I want to add an ALL STATES option in the drop down box.
>
Yet what should its value be? An asterisk? A smiley face?
>
Select * from CRAP_ABOUT _STATES where STATE= *
Select * from CRAP_ABOUT _STATES where STATE= %?%
Select * from CRAP_ABOUT _STATES where STATE= :>)
>
how do I cause an ALL States to occur?
thanks in advance for your help.
Up yers to the rest of you.
>
>
>
>
>

[Mr. SweatyFinger]

Re: Default= ALL

No sh& sherlock, but how do i get that to work in the wizard.

I would have to remove the parameter..

[Mr. SweatyFinger]

Re: Default= ALL

was that the answer to my question?
the answer: no

I mean honest to MVP Pete.
Can't you read>???

the only way to defeat idiots is to become more obnoxious so they go
away!!!!!!!!!!! !
Leaving only smart guys.

>>>>>>>>>>>>>>> >>>>Now I want to add an ALL STATES option in the drop down
>>>>>>>>>>>>>>> >>>>box<<<<<<<< <<<<<<<<<<<<<<< <<<<<<<<<<

Yet what should its value be? An asterisk? A smiley face?

Select * from CRAP_ABOUT _STATES where STATE= *
Select * from CRAP_ABOUT _STATES where STATE= %?%
Select * from CRAP_ABOUT _STATES where STATE= :>)

how do I cause an ALL States to occur?
thanks in advance for your help.
Up yers to the rest of you.

[Rad [Visual C# MVP]]

Re: Default= ALL

On Wed, 3 Jan 2007 01:48:38 -0700, Mr. SweatyFinger wrote:

Use the '*' as the value and change the query to be LIKW

For example given the following table, NITWITS with the test data

NAME
-----
Mr SweatyFinger
Test
Another Test

The following statment,

Select * from NITWITS where NAME LIKE '*'

Returns all the rows (3)

[Mr. SweatyFinger]

Re: Default= ALL

thanks you rock,