I have a database that houses project information. Each project has equipment that is associated with the project. My main goal is that I want to be able to do some reporting on the quantities of equipment, for certain time spans depending upon in service dates. (ie. I want to show the quantity of widgets going into service between 6/1/2005 and 6/1/2006).
This reporting is going to be used by people not familiar w/ Access, so I was thinking that I could create a form that would display the different types of equipment in a drop down box, and then give text boxes where you could put in the date range. The user would then select the type of equipment, and date range.
The problem that I am running into is that I am unsure how I can use this information that I select/input as part of a query to extract the info from the database, and in the end, display that data selected in a report. Any ideas, as my SQL isn't what it once was? Maybe there is a better way to do this that I am not thinking of? Thanks much in advance.
jamey84
This reporting is going to be used by people not familiar w/ Access, so I was thinking that I could create a form that would display the different types of equipment in a drop down box, and then give text boxes where you could put in the date range. The user would then select the type of equipment, and date range.
The problem that I am running into is that I am unsure how I can use this information that I select/input as part of a query to extract the info from the database, and in the end, display that data selected in a report. Any ideas, as my SQL isn't what it once was? Maybe there is a better way to do this that I am not thinking of? Thanks much in advance.
jamey84
