Search results

Thanks again CJ_London, That's what is so strange about the whole thing. The field value is obtained from a field list and I can assure that there is no space in the name "June". I will double check but I 99.99% certain. I really appreciate your taking the time to restore my sanity. I...

Thanks CJ_London. Sorry about the sparse info. "June" is actual text in the table. Here is the SQL: Disclaimer: I do not write SQL statements. This was copies from the SQL View in Access. Thanks. SELECT TblCarriersMain.CarrierName, TblCarriersMain.CarrierIDNumber...

I cannot get my query to return result when I enter the month of "June" as search criteria. June is listed in the table and query, every other month is returned except June. I have attached two example for your reference. Thanks.

Thanks for the response, pbaldy. I certain that is the answer to my inquiry. Have a nice day!

Hi, I am new - sort of. I use to post a long time ago when I worked with Access on a daily basis. My post today is probably already listed somewhere in the forum so please forgive me. I am trying to have my form auto-populate a field when I select an item in a drop down list in another...