Search results for query: *

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...

That works marvelously!! Thanks a lot

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?

The table was made in access, and the query is in a mdb database.

yes

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...

Any takers?

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...