Search results for query: *

That is so simple and it works perfectly!! Thank you so much!! -cassie

I have a query that filters if a record is "Multi-cultural" then if it is I run it through a second query that will search an [Additional information] Memo field based a one word value the user enters. I know how to set in the criteria Like "*word*" and it will search...

Is there a way to make a multiSelect combo box? Looking at the definitions of both with a list box you can have multiple choices but you cannot add to the list. With Combo box you can add to the list but you cannot select multiple choices. Is there a way to add to a multiselect combobox or...

I don't know if it will work, but i will try with some other info I have gotten. Thank you! I'll try to expalin the percentage calulation better and maybe someone can help me translate into how I could use the information already given. I count how many categories, each category is a field...

I have a report that is composed of several subreports put together. I have also made code in the On Open procedure of this main report that would calculate a precentage that would be different for each record listed in the report. I added a text box in each subreport named for the calculated...

Oh, wow, I didn't know you could make it into one field. I had each category be a different field. I will try to make it one field and now I understand the criteria part. Thank you for your help. I will try it out. Thank you!! -cassie

Thank you, it has been a good start in the direction I am headed. -cassie

I am making a search by allowing the user to check many boxes that are categories under which resources are listed. A resource can be one or many categories usually many. I did another database similar to this with only two or three choices and it worked by making a query. I had two tables in...

I have several levels of data in a report based on queries. Some of the data may be on more than one level.(If it gets on level one and meets another criteria it would be on level two). How do I determine if it is a repeat and then delete the one on level one-to keep the one that meets the...

I have several check boxes for the user to choose from. These are to match up with a table and then show an end result of matches on many levels. There are almost 20 checkboxes and I am only allowed to join 10 of these in the relationships window before getting booted out of access. How do I...

I have made a query that can filter one record. In the form I am trying to create a procedure that will determine if there is a record in the query and if there is goto that record in the form. Any help is appreciated. Thank you.

I am trying to create a search that allows users to select many criteria. Then based on that criteria make a report that will rank the results based on how well it matches. I can make a query that gives perfect matches and I have begun to make queries that satisfy one or two criteria. Must I...