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