Hi all, I have an Access database I use at work and to be honest I am very naive at using this program. All I really use it for is to run queries, since I already know SQL syntax (I don't much care for the query design tool) i just type them by hand. What I would ideally like to do is make a report that would allow the users to choose a date from a dropdown, and then it would basicly show the results from a bunch of queiries for that date in the report with graphs and what not. I'm sure this is a pretty simple thing to do, but I just have no idea where to start.
There are a few fundamental hurdles that I run into. For example, since I want the user to input something (the date), do I need to make a form? From what I understand, forms are just for entering data into the db but I am not sure about that. I went out and bought the Access 2002 Bible, but its a bit heavy (~2000 pages) so I haven't spent too much time in it. Any shoves in the right direction would be really appreciated.
There are a few fundamental hurdles that I run into. For example, since I want the user to input something (the date), do I need to make a form? From what I understand, forms are just for entering data into the db but I am not sure about that. I went out and bought the Access 2002 Bible, but its a bit heavy (~2000 pages) so I haven't spent too much time in it. Any shoves in the right direction would be really appreciated.