Recent content by otrivine

hello there, I've tried to create this query but I failed many times I want when the user select" YES" , the counter equals 10 "No" , counter equals 0 and" Maybe " equals 5 . and make a sum to all combos (15,20,0....) PS: Only counts when it's enabled The file is attached

thank you guys that really helped;)

hello there , can anyone tell what is wrong with this code:mad:? : DoCmd.OpenForm "multiuseform", , , "([Dateofentry] = #" & Me![text1] & "#) And ([typeoffood] = " & Me!combo1 & ")" thanks in advanced dateofentry is DATE typeoffood is STRING

thank you so much vbaInet i appreciate it

well, thank you both and let me put it like this the table is The source just like vbaInet said, and i want the query: table query(or another table) Excellent = 100 good = 75 accepted = 50 weak < 50 ( any number...

thanks for the quick response they are just like this excellent good accepted weak (the user chooses one of the four "comboBox" and i want the other table or query in number 0 to 100 the purpose is to make a simple bar graph, check the attach

hello there i have one table has a column called evaluation ( text data type ), and i want to take the data and convert it into a number data type in another table or a query , something like the following excellent=90 to 100 good = 80 to 89 accepted = 60 to 79 under 60 is failed please help...