Long ago I did this in Microsoft Access... what I did was offer a set of fields/filters to search on, and interactively built an SQL query string based on it. I toggled the display of the SQL so that I could see it (and use it for reports) but they didn't have to. It shouldn't be hard to do in any modern platform.
Long ago I did this in Microsoft Access... what I did was offer a set of fields/filters to search on, and interactively built an SQL query string based on it. I toggled the display of the SQL so that I could see it (and use it for reports) but they didn't have to. It shouldn't be hard to do in any modern platform.