Recent content by Sianboy

I see that helps a lot! My idea is what you said, linking what is selected in the combo box to the query for running. But in the first place, how to create a case statement for these?

Hey All, I am a non-sql user here, who is linking criterias from forms to my query to generate reports and I facing a problem right now. Currently, I have a combobox from a form that displays such values; "-","Less than","More than" and "Equal to" and there is a corresponding text box in the...

Hey All I need help on this query. There is a combobox displaying different Car CC like "<661cc", "661cc - 1600cc" and ">3000cc". I aware I need to convert the non numeric text to numeric expressions before linking the criteria to the query itself. However, I have tried using multiple column...

Hey I got a school IT project and encourtered this problem hope you all can help me :) I have completed my form, query and report le. But problem is, if I want to show a report that tells the users there is no records found, how am I support to do it? Currently my report only shows all results...

Can only click on "Any", "Auto" and "Transmission" these 3 only. In which once "Any" is selected, all cars will be displayed. Can mutli column combo box solved this problem? But I not sure how 2 create one.

I see I get what you mean. Just wonder how to create two column within one combo box? And also as simplified as possible.

I see thanks for the clarification. Yeah what I intend to do as you said, is one combox box with two column, in which 1 is visible and the other is invisible. Is there a way to do such combox box, whereby the value of the invisible column will be sent to the query as criteria? And at the same...

I didnt mean this way, is a inquiry and hope those who know can help me.

That interesting! In this case, how you link the "No Max" value to both the column within the same combo box? That might work and 99999999 will be more than sufficient for the range itself.

Here another similar question, The database will show all car's particulars as long its registered date matches the year inside the combo box of the form. For example, a car with registered date of 1999 will be displayed once the user choose 1999 in the combox box. The problem now is, what if...

Hey all, I a student who is doing a project for IT course now and non-sql user, therefore the solutions suggested should be siimplified or minimal code writing. Here the question. I got a form that shows all details of a car as long its price is within a range. For example, any car with values...

Hey I got a query problem here and hope you all can help me. I doing a school project and non-sql user here therefore the solutions provided should be as simple as possible. Here the situation. In my database, I got a field called "Transmission" and the records inside are either "Auto" or...