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.

 

[Guest]

The simplest way is:

Select * from CRAP_ABOUT _STATES

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

Peter

 

[Mr. SweatyFinger]

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

I would have to remove the parameter..

 

[Mr. SweatyFinger]

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.


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]]

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]

thanks you rock,