Access '97, I guess this function wasn't defined back then. That answers some questions though, because I've been using a book that hasn't been too much help.
Are there any other ways of solving this problem without that function?
I set up my query as follows, and I get an undefined function message box for the Replace function. Did I set it up right?
SELECT [Outgoing Doc log_1].[Log Number], [Outgoing Doc log_1].[Document Number], [Outgoing Doc log_1].[Document Title], [Outgoing Doc log_1].Author, [Outgoing Doc...
I have a table in my database that lists different documents, and each document has an assigned 8-10 digit document number. Each document number is unique, however the basic structure of the number is about the same. For example, one number might be 546-RES-09-092 and another might be...
Well, if I specify a status to look for, it returns all the documents that have been given a document type for that particular status. For example, if I specify "Completed" it will return all the Completed documents that I have assigned a type to. However, if the type field is empty it skips...
That works, but is there a way where I can leave the fields blank and it will return all values, instead of just the records that have a specified document type?
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...
This solution is better, however it still doesn't return the results I was looking for. When I leave the Type query field blank I only get back the status of documents that have been assigned a type all other documents are left out. Yet, when I enter the Type and leave the Status field blank...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.