Hello,
I'm having a problem with two queries that I want to interact. I have one query that searches for a certain Document Status and the other that searches for Document Type. I want to be able to search for a particular type of document and then continue to narrow the search by entering the status of the document. However, when these two queries are connected with an AND statement, I can't leave one query blank because all I receive is an empty table.
So, I guess the question is, how do I set this up so that an empty field will return all records?
Here's my query: SELECT [Outgoing Doc Log].[Log Number], [Outgoing Doc Log].[Document Number], [Outgoing Doc Log].[Document Title], [Outgoing Doc Log].Status, [Outgoing Doc Log].Author, [Outgoing Doc Log].[Document Type]
FROM [Outgoing Doc Log]
WHERE ((([Outgoing Doc Log].Status) Like [In-progress, Post Check, or Completed?] & "*") AND (([Outgoing Doc Log].[Document Type]) Like [Narrow search by entering Doc Type] & "*"));
Any help would be greatly appreciated.
Thanks
I'm having a problem with two queries that I want to interact. I have one query that searches for a certain Document Status and the other that searches for Document Type. I want to be able to search for a particular type of document and then continue to narrow the search by entering the status of the document. However, when these two queries are connected with an AND statement, I can't leave one query blank because all I receive is an empty table.
So, I guess the question is, how do I set this up so that an empty field will return all records?
Here's my query: SELECT [Outgoing Doc Log].[Log Number], [Outgoing Doc Log].[Document Number], [Outgoing Doc Log].[Document Title], [Outgoing Doc Log].Status, [Outgoing Doc Log].Author, [Outgoing Doc Log].[Document Type]
FROM [Outgoing Doc Log]
WHERE ((([Outgoing Doc Log].Status) Like [In-progress, Post Check, or Completed?] & "*") AND (([Outgoing Doc Log].[Document Type]) Like [Narrow search by entering Doc Type] & "*"));
Any help would be greatly appreciated.
Thanks