Recent content by sarab99

I found it very simple Like "*" & [Table]![Field]

Hi I am using a table that stored all criteria I need. I have a query that show result from criteria table. Iam using "In (SELECT [Field] FROM MyTable)" But the result shows only exact match. I want to view result using like "*" to view all result that contain a single word for example...

Thank you Mr. SOS it is working now with your great creteria :) Thanks to others who trying to help. Regards,

DMAX() dosnt work with query creteria I got error message. Could you please advise. Thank you

Hi Expert I need query to return last 10 days from last date in the table. I have use the following creteria >=DateAdd("d",-1,Date())-10 but this will return the last date from the current date. I need to return the last 10 days depends on last day in the table. note the table called...

Dear Chrisopia, could you please explain where to put this code ? thank you

Can any one updat my file in first post? I dont know how to do it !

Mr. john the linked you gave me belong to listbox what I am loking for is for combobox. I need the result to show in the combobox that I have search in.

Mr. John, this not mach my required. Any help please ?

Good day experts I am a newbie in MS Access and I would like to make a combobox that searching its contents by enter any letter. for example if I want to find China I enter "ina" or "hina" or event on letter "n" I appreciated if any expert can update my attached databse file to my request...