Ho do you bypass a parameter?
eg, we have a query set up to ask the user what divisisons info is required, sometimes we want to run all divisions together, how do you do this?
Ho do you bypass a parameter?
eg, we have a query set up to ask the user what divisisons info is required, sometimes we want to run all divisions together, how do you do this?
Show the query sql statement.
Try using Like operator and wildcard in the parameter.
Like [Enter Division] & "*"
Are nulls allowed in the field?
Maybe this will help: http://datapigtechnologies.com/flash...earchform.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.