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!

  • Congratulations gkittelson 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: *

  • Users: mvb00
  • Order by date
  1. mvb00

    Searching a date range

    Would that enable me to have a search for a date range which is not a predefined query. I'd like to be able to have and input box whereas one would be able to determine ones own specific range of dates to be found. Thanks
  2. mvb00

    Access database query setup

    Yes, my database is designed in third normal form. With the system of checkboxes you recommend, would the option of [male] or [female] be part of another form/query called by the main search interface? Without a knowledge of SQL it seems that setting up this list of choices which than calls a...
  3. mvb00

    Access database query setup

    Could you provide a little more info about the select statement? I am not very familiar with SQL and have learned a tremendous amount in the last 36 hours. Please be a little more specific in what is happening in the example of code you provided. Much obliged.
  4. mvb00

    Access database query setup

    I will read the article and attempt your advice. Cheers.
  5. mvb00

    Access database query setup

    There are different values for ethnicity. It could consist of Asian, Black, Caucasion, Hispanic so on and so forth. I would like to allow the user the ability to search for multiple criteria. An example of this could be allowing a search for all database entries from April 5, 2003 to April 7...
  6. mvb00

    Searching a date range

    How can I create a query which will search by date range. I have used the wizard along with BETWEEN #[Enter Start Date]# AND #[Enter End Date]# To attemp this but I am brought to a new windo which says select search and there is an empty cell. Where do I go from here?
  7. mvb00

    Access database query setup

    If my fields consist of a date, age, race, ethnicity, behavior, councilor and location (for example)......How would I create a simple interface in order to search any of the existing fields of information within the table. Would I have to predefine each possible combination of search? Is there a...
  8. mvb00

    Access database query setup

    Could someone please help me. I am attempting to help a friend setup a database (using access) for creating a searchable table of their clients. What is the most efficient way to set up query which will create a unique listing of records? For example, I'd like to find how many size six green...

Part and Inventory Search

Back
Top