I have a query with parameters to filter some details, but somtimes I want to view all details.
M M.A.Halim Apr 4, 2007 #1 I have a query with parameters to filter some details, but somtimes I want to view all details.
M Mikal via AccessMonster.com Apr 4, 2007 #2 M.A.Halim said: I have a query with parameters to filter some details, but somtimes I want to view all details. Click to expand... Try entering "[MyParameter] or *" in the query grid. Omit the quotes. Mike
M.A.Halim said: I have a query with parameters to filter some details, but somtimes I want to view all details. Click to expand... Try entering "[MyParameter] or *" in the query grid. Omit the quotes. Mike
M M.A.Halim Apr 10, 2007 #3 Thanks Mikal I have tried this, it worked but access added " Like" so "[My Parameters] or Like(*)" without the quotes. Mikal via AccessMonster.com said: M.A.Halim said: I have a query with parameters to filter some details, but somtimes I want to view all details. Click to expand... Try entering "[MyParameter] or *" in the query grid. Omit the quotes. Mike Click to expand...
Thanks Mikal I have tried this, it worked but access added " Like" so "[My Parameters] or Like(*)" without the quotes. Mikal via AccessMonster.com said: M.A.Halim said: I have a query with parameters to filter some details, but somtimes I want to view all details. Click to expand... Try entering "[MyParameter] or *" in the query grid. Omit the quotes. Mike Click to expand...
