Default= ALL

  • Thread starter Thread starter Mr. SweatyFinger
  • Start date Start date
M

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.
 
The simplest way is:

Select * from CRAP_ABOUT _STATES

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

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

I would have to remove the parameter..
 
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.
 
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)
 
Back
Top