I want to be able to enter any 1 parameter and return all the records. It returns none even though i have it set as an optional prompt. Probably something simple that I am not seeing. Here is my code i am at a loss.
{PAUDIT.DATE} = Minimum(not HasValue({?Start Date(yyyyMMdd)}) and
{PAUDIT.DATE} = Maximum(not HasValue({?End Date(yyyyMMdd)}) and
(not HasValue({?Medical Record Number}) OR {PAUDIT.MR_NUM} =
{?Medical Record Number}) and
(not HasValue({?Accession Number}) OR {PAUDIT.ACC_NUM} =
{?Accession Number})
Thanks in advance.