If "Enter parameter value" is empty then show all

Y

YZF

Registered User.

Local time

Today, 17:58

Joined

Nov 29, 2005

Messages

19

• Jan 5, 2006

• #1

When i run my query (or report), access asks me to input some parameters (e.g. begining date and ending date).If i fill those numbers, i get results. But if i leave this field empty, i have empty query/report aswell. Is it possible to make it show all dates if i leave filling fields empty?


Thanks

 

I

Ian Mac

Registered User.

Local time

Today, 15:58

Joined

Mar 11, 2002

Messages

179

• Jan 5, 2006

• #2

Hi,

Use:

(>=[Enter Start Date] Or Like "*") And (<=[Enter End Date] Or Like "*")

 

Y

YZF

Registered User.

Local time

Today, 17:58

Joined

Nov 29, 2005

Messages

19

• Jan 6, 2006

• #3

Thanks ! Now its ok