Hi All,
I'm working on a LOT of VBA code that generates reports from Excel.
I reckon it's a really stupid idea to use Excel and VBA to run "queries" on an worksheet so I'd like to do it in a database environment.
I successfully ported the required table and data into OpenOffice base. The problem now is that I need to run a report that takes in user input for example in a pizza database:
"Show me total use of ham on a weekly basis and consolidate that on a month by month basis."
Where "ham" would be an ingredient that the user could change for say, "pepperoni".
How do I create a report that takes user input? Do I need to do it with a subform? Can I connect a form to a report?