Search results

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...

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...