Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Wfuphan

    Wildcards?

    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?
  2. Wfuphan

    Wildcards?

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

    Wildcards?

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

    Query Problem

    That works marvelously!! Thanks a lot
  5. Wfuphan

    Help Needed

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

    Help Needed

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

    Help Needed

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

    Help Needed

    yes
  9. Wfuphan

    Help Needed

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

    Query Problem

    Any takers?
  11. Wfuphan

    Query Problem

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

    Query Problem

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

Part and Inventory Search

Back
Top