Hi there,
Thank You for your prompt response.
My name is Akash
By null i mean i want to show fields as per my category.
my category consist of complete and in-complete task.
i am using parameterized query in which input for date search is through textboxes.
textboxes are dateFrom and DateTo
what i am trying to achieve using my report is to display both the categories complete and in-complete, when i generate a report through date search.
Form through which i am trying to achieve this functionality is named as tasksearchformbycombobox
My report is generated using Command button 60, this command button opens my report which based on query named " Copy Of TaskQuery22"
in my query i have included the functionality for date search using textboxes from from tasksearchformbycombobox but when i generate my report it only gives me values for completed task and it doesnt show me in-complete task.
in-complete task are those task where completed date is not mentioned.
Moral of the story - my date search works but it shows value where my datefrom and dateTo are enetered but if any of them are null or no values or field is empty then it doesn't show me on my report.
For Reference i am attaching my database please check
Please help me thank you
hi
ashah08 (what is your name?
I'm not sure what to look at ... currently viewing DateSearch but you didn't specify a form. By the way, "Null" means the ABSENCE of a value ... can't show what isn't there. If you want to find Null, as well as values, that needs to be in the criteria