Good evening, everyone: I've been a long-time user of OpenOffice and recently rejoined this great list in hopes that someone may be able to assist me with a little project...
Being a tech, not a developer or database admin, I'm hoping someone can give me a little guidance with this troubling step in a project I've been working on... I have a client that's asked me to design a small, simple database where they can keep track of their customers... Names, addresses, etc. I've generated simple queries to search by particular data, let's say to list customers in a particular state, then by city. I've tied these to reports, and everything is working beautifully. However, we are looking for a way to generate a report based off of certain search criteria that will be changing on each search. Let's say, if we wanted to list each client with the last name of Jones... We'd like to have a search box, type in the name "Jones" and the particular field we are searching, and then generate the report accordingly... If anyone has any idea how this can be done, if this can even be done, I would greatly appreciate someone throwing me a bone. Digging through documentation, different forums has produced nothing useful as of yet. Thanks in advance for any assistance.
