Parameter Prompts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Am trying to set criteria using a parameter that will give result for a selected record using a company code, if not return all records. Any help is appreciated. eg

[Type Company Code:] is the prompt but need user to type a particular code to show those records or type nothing and return all records
 
How about this in your criteria line...

= IIf(Len([Type Company Code])>0,Like [Type Company Code],
Like "*")

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message
Am trying to set criteria using a parameter that will give
Click to expand...
result for a selected record using a company code, if not
return all records. Any help is appreciated. eg.
[Type Company Code:] is the prompt but need user to type a
Click to expand...
particular code to show those records or type nothing and
return all records.
 
Put the following into the criteria box:

[Type Company Code:] OR [Type Company Code:] Is Null

If you only want records that have a company code (ignore the nulls) then

Like IIF(IsNull([Type Company Code:]),"*",[Type Company Code:])
 
Champion John Spencer. Not so frustrated now.
Thanks heaps!

----- John Spencer (MVP) wrote: -----

Put the following into the criteria box:

[Type Company Code:] OR [Type Company Code:] Is Null

If you only want records that have a company code (ignore the nulls) then

Like IIF(IsNull([Type Company Code:]),"*",[Type Company Code:])
Am trying to set criteria using a parameter that will give result for a selected record using a company code, if not return all records. Any help is appreciated. eg.
[Type Company Code:] is the prompt but need user to type a particular code to show those records or type nothing and return all records.
Click to expand...
Click to expand...
 
Back
Top