Access - Sql query

Hi , I have MS ACCESS file which has some forms , out of this in 2 forms i need to put a filter conditions based on the options that user has selected , this filter needs to be SQL query or VB code .. i just need the results . i have written the SQL query which does not work as expected , forms name are [login to view URL] [login to view URL] FILTER respective queries are qryFilter qryEventFilter respective tables are Jazzdata Event when the FILTER forms loads we need to show 15202 records from Jazzdata , after which based on the options that user has selected we need to show only records that matched with user selected options , same applies for the EVENT FILTER form and Event table. this is very very easy for some one who has versatile experience on access , this cannot take more then 30 mins .. my budget is $30 i have attached file here - [login to view URL] , let me know if you have any questions , thank you. Regards, Ashok NOTE : no milestone , i only pay for only results not time and effort.