Show all unless selction...

[geckodfw]

I need a criteria that will show all the records if a criteria is not entered.

If the region "CANADA" is entered into a parameter, then show only "CANADA". If nothing is entered into the parameter, show all the records.

I have tried

IIF(IS NOT NULL, [parameter], "&quot

I am stuck. Help!

Thanks.

 

[bethabernathy]

Hi There: I am confused are you running a query?

Beth

 

[geckodfw]

Yes, it's a query in Access 2000. Sorry about that.

 

[bethabernathy]

Hi There: Maybe I am missing something, but if you want to show all the records, there should be nothing entered in the Criteria row on the query. Let me know more details...

beth@integratedresourcemgmt.com

 

[geckodfw]

I want to be able to select records from the table based on a parameter. If there is data in the parameter, I want only records based on that data returned. If there is nothing in the parameter, I want all the records returned.

If the user inputs wants to get "CANADA" they will type in "CANADA" for the parameter. If they don't type anything in, then they want to see ALL the regions.

 

[bethabernathy]

Hi There:

So, are the users using the query to enter criteria? Also, I am assuming this query is not working, correct?

Feel free email your database - can you zip it up and send it to me.

Beth beth@integratedresourcemgmt.com

 

[bethabernathy]

Hi Again- One more thought... Are you linking tables in the query? If so, you may need to change the Join Properties.

Beth beth@integratedresourcemgmt.com

 

[CosmoKramer]

Try this in the criteria of your query:

Like [parameter] & '*'

If nothing is entered, all records will be returned, and if 'CANADA' is entered all records STARTING with CANADA will be returned......