Форма поиска в нескольких полях, не работает только диапазон дат
У меня есть запрос, который фильтрует таблицу на основе данных, введенных в форму поиска. Поля: IssueID, IssueDescription, IssueOwner, IssueStatus и Диапазон дат выпуска (с использованием IssueDateBegin и IssueDateEnd). Это прекрасно работает для всех полей, за исключением диапазона дат. Вот мой код:
SELECT Issue_Tracker_Table.IssueID, Issue_Tracker_Table.IssueDescription, Issue_Tracker_Table.IssueDate, Issue_Tracker_Table.IssueOwner, Issue_Tracker_Table.IssueStatus
FROM Issue_Tracker_Table
WHERE (((Issue_Tracker_Table.IssueID) Like "*" & [Forms]![Issue_Search_Form]![IssueID] & "*") AND ((Issue_Tracker_Table.IssueDescription) Like "*" & [Forms]![Issue_Search_Form]![IssueDescription] & "*") AND ((Issue_Tracker_Table.IssueDate) Between [Forms]![Issue_Search_Form]![IssueDateBegin] And [Forms]![Issue_Search_Form]![IssueDateEnd]) AND ((Issue_Tracker_Table.IssueOwner) Like "*" & [Forms]![Issue_Search_Form]![IssueOwner] & "*") AND ((Issue_Tracker_Table.IssueStatus) Like "*" & [Forms]![Issue_Search_Form]![IssueStatus] & "*")) OR (((Issue_Tracker_Table.IssueID) Like "*" & [Forms]![Issue_Search_Form]![IssueID] & "*") AND ((Issue_Tracker_Table.IssueDate) Between [Forms]![Issue_Search_Form]![IssueDateBegin] And [Forms]![Issue_Search_Form]![IssueDateEnd]) AND ((Issue_Tracker_Table.IssueOwner) Like "*" & [Forms]![Issue_Search_Form]![IssueOwner] & "*") AND ((Issue_Tracker_Table.IssueStatus) Like "*" & [Forms]![Issue_Search_Form]![IssueStatus] & "*") AND (([Forms]![Issue_Search_Form]![IssueDescription]) Is Null)) OR (((Issue_Tracker_Table.IssueID) Like "*" & [Forms]![Issue_Search_Form]![IssueID] & "*") AND ((Issue_Tracker_Table.IssueOwner) Like "*" & [Forms]![Issue_Search_Form]![IssueOwner] & "*") AND ((Issue_Tracker_Table.IssueStatus) Like "*" & [Forms]![Issue_Search_Form]![IssueStatus] & "*") AND (([Forms]![Issue_Search_Form]![IssueDescription]) Is Null)) OR (((Issue_Tracker_Table.IssueID) Like "*" & [Forms]![Issue_Search_Form]![IssueID] & "*") AND ((Issue_Tracker_Table.IssueStatus) Like "*" & [Forms]![Issue_Search_Form]![IssueStatus] & "*") AND (([Forms]![Issue_Search_Form]![IssueDescription]) Is Null) AND (([Forms]![Issue_Search_Form]![IssueOwner]) Is Null)) OR (((Issue_Tracker_Table.IssueID) Like "*" & [Forms]![Issue_Search_Form]![IssueID] & "*") AND ((Issue_Tracker_Table.IssueDescription) Like "*" & [Forms]![Issue_Search_Form]![IssueDescription] & "*") AND ((Issue_Tracker_Table.IssueStatus) Like "*" & [Forms]![Issue_Search_Form]![IssueStatus] & "*") AND (([Forms]![Issue_Search_Form]![IssueOwner]) Is Null)) OR (((Issue_Tracker_Table.IssueID) Like "*" & [Forms]![Issue_Search_Form]![IssueID] & "*") AND ((Issue_Tracker_Table.IssueDescription) Like "*" & [Forms]![Issue_Search_Form]![IssueDescription] & "*") AND ((Issue_Tracker_Table.IssueDate) Between [Forms]![Issue_Search_Form]![IssueDateBegin] And [Forms]![Issue_Search_Form]![IssueDateEnd]) AND ((Issue_Tracker_Table.IssueStatus) Like "*" & [Forms]![Issue_Search_Form]![IssueStatus] & "*") AND (([Forms]![Issue_Search_Form]![IssueOwner]) Is Null)) OR (((Issue_Tracker_Table.IssueID) Like "*" & [Forms]![Issue_Search_Form]![IssueID] & "*") AND ((Issue_Tracker_Table.IssueDate) Between [Forms]![Issue_Search_Form]![IssueDateBegin] And [Forms]![Issue_Search_Form]![IssueDateEnd]) AND ((Issue_Tracker_Table.IssueStatus) Like "*" & [Forms]![Issue_Search_Form]![IssueStatus] & "*") AND (([Forms]![Issue_Search_Form]![IssueDescription]) Is Null) AND (([Forms]![Issue_Search_Form]![IssueOwner]) Is Null)) OR (((Issue_Tracker_Table.IssueDate) Between [Forms]![Issue_Search_Form]![IssueDateBegin] And [Forms]![Issue_Search_Form]![IssueDateEnd]));
Я ценю всю помощь и руководство.