Search results

Hi, I am trying to filter on two particular words in a Microsoft query design grid. I am using Like "*INDOOR*", which works great to pull all the rows with the word “INDOOR” in the description. Now I would like to update my query to pull both “*INDOOR*” and “*OUTDOOR*” for rows that have...

I apologize, I had the wrong sample description.

Hi, I appreciate the prompt response Ranman. Yes, it is a Short Text field. The data is not returning. I know it is in there because I did a raw dump to Excel and searched for "RRU" and received several rows returned.

Hello, I hope this is not too complicated. I have very little experience in SQL, so I am hoping this does not require SQL code.  I am working with a Microsoft Access query and in the query design I am trying to find in a description field (Short text) all records that has the word RRUxxxxxx...

Thank you Mark for your response. I am not sure if I want or need to calculate the years. I have two columns, one called "Begin Year" and another column called "End Year". I need to see where the begin/end year is not the same. Example below shows the first row as different years...

Hello, How can I get my query to output years that does not equal the same year? For example: I have a Begin Year and an End Year. I need to see if the begin year is not equal to the end year (10/10/2016 = 10/10/2017 ) I would like to add the expression to my query design criteria Begin...

Oh, I used this and it works. Yaaaa! (Like "Apples*" Or Like "Oranges*" Or Like "Pears*") And Not Like "Pears Today*" Thank you again for your help.

Hi pbaldy, Thank you so much for responding. I tried your structure, but it is still not working. Sorry, I want to eliminate all other items associate with "Pears Today". So, I don't want to see "Pears Today 1, "Pears Today 2", etc.

Hello, Is it possible to create a criteria in a query to pull specific data and eliminate other specific data at the same time? This criteria is working well to output all Apples, Oranges and Pears. But, in the list is data with “Pears Today” and I don’t want the see “Pears Today”. How can...

OMG!!!! I am dancing around. Thank you SO much Gina. I really appreciate you taking the time to help with the code. :-) I see how you linked both the child and master using code. I am filing this data for future use. Thanks again. Now I can start using my tool.

Thank you so much! I appreciate your time.

Thank you JHB. I would love to post my db. I am using Access-2007-2013. Will that do? I don't see where I can convert to 2010.

Thank you all for responding, but I nothing is working. When I click on the Filter button, I will get 1 or 10 records to display and in no particular order. So frustrating. I have been researching for a couple of days and can't seem to find the issue. Ugh!.

Hello, I cannot get my filter button to remove the filter from my subform. Can you help please. I am using MSAccess 2013. I have a parent form (frm_WO_Status_Form) with a combo box (Proj Manager) and I am filtering a datasheet subform (subfrm_WO_Status_Form) by user name. This works great...

Hello Forum Experts, Is it possible to perform a function in Access 2010 like the "Text to Columns" function in Excel? I would like to split concatenated text in one column and place into a new column. Example: 5551111-Blue- Play I would like to split the "5551111" number and place it in...

Aww, got it. Okay, thanks so much for your help. It is working great! :)

Great! That is what I was looking for. Is it possible to enter multiple work order numbers or no?

Hello, Is it possible to do a criteria like the "Between" to pull data like a work order number? Ex WO#: WO5551212 I would like to be prompted to enter a Work Order Number when I run a query, then have the query display all of the data for that particular work order number. Thank you.

Yes it does work. But, when I test the data, I receive the message box whether I have a duplicate field or not. I need to to find the dup and inform the user that there are another work order number for that number. Otherwise, just record the new work order number if no dup exist.

The WorkOrd_Number is text data type. I have a combo box (Cbowonum) pulling the workorder numbers from a query. The user selects the workorder number from the combo box. I hope I answered your question.