I have a relatively simply request, but I am new to access and cannot figure out how to do this.
I've searched Datapig and Baldyweb and others, but I cannot figure out what I need to do specifically, and so I'm turning to "the forum"!
I have an itty bitty database based on an Excel file that I would like to create a report for other people. The importance of the file is mostly text, and a few other dates or descriptive columns based on text.
I'm not sure whether a 'form' or a 'report' is best for me to conclude with...
What I desire: Based on input from 'the form user', I want someone to be able to input parameters such as I have in the form (only I will use more parameters, once I know what is happening here I will be able to replicate more fields), and be able to view a "report" type output, BASED ON whatever input parameters the user entered into 'the form'.
e.g.- If you open the form, and you type in the headline "copd", you get 10 results or so returned in the 'mainquery'. What I want is a report that utilizes these 10 results from the form, and sets them in a pretty report-like setup so that the user gets all the resulting data in a nice slick format. Not a database row-and-column format. Should be simple right? Well... that's how dull I am.
So can someone help me with this? I'm good at SQL but not VBA. But I'm willing to learn anything!
Thanks for any help.
(ps- I tried to upload my little DB but I got an error: my 948kb DB was beyone the 500kb DB allowed to update... Really?!?!?!)