Okay, now for my next question . . . with heartfelt thanks for Rich for helping with my last question in the Forms forum.
I wish to make this resource (db) that I'm working on (purchase log) available to my certifying official(s) to assist in official audits of the purchase program. Therefore, I’m attempting to make it menu-driven so s/he won’t have to try to learn how to modify a query, etc.
I plan to have an item on the switchboard for a report. I’d like for another screen to come up when that option is selected, asking the user (IOW, the certifying official) to enter the reporting period’s beginning date in one field, and the reporting period’s ending date in another field. Then, s/he will click on the “Go” button and the report will be generated by plugging those dates into the query.
Now, if any of you know the Access 2000 Bible well enough to point me in the right direction by giving me page numbers (or even chapters) so I don’t have to leaf through it or try to find the right topic in the index, that would be great! Or even if you could give me an idea of what (i.e., key words) to put in Access’s “help” feature that will get me started. Or perhaps someone will be patient enough to guide me through step-by-step! Any of those will be most appreciated.
I’m thinking this will require a macro or two but macros are not something we covered extensively when I took the Access course at the local community college back in 1999. And since it is been so long since the course, I feel I am truly, as it stated below my user name, “in over my head!”
I wish to make this resource (db) that I'm working on (purchase log) available to my certifying official(s) to assist in official audits of the purchase program. Therefore, I’m attempting to make it menu-driven so s/he won’t have to try to learn how to modify a query, etc.
I plan to have an item on the switchboard for a report. I’d like for another screen to come up when that option is selected, asking the user (IOW, the certifying official) to enter the reporting period’s beginning date in one field, and the reporting period’s ending date in another field. Then, s/he will click on the “Go” button and the report will be generated by plugging those dates into the query.
Now, if any of you know the Access 2000 Bible well enough to point me in the right direction by giving me page numbers (or even chapters) so I don’t have to leaf through it or try to find the right topic in the index, that would be great! Or even if you could give me an idea of what (i.e., key words) to put in Access’s “help” feature that will get me started. Or perhaps someone will be patient enough to guide me through step-by-step! Any of those will be most appreciated.
I’m thinking this will require a macro or two but macros are not something we covered extensively when I took the Access course at the local community college back in 1999. And since it is been so long since the course, I feel I am truly, as it stated below my user name, “in over my head!”
search for Parameter queries and or Criteria, you only need to base your Report on a query and set the criteria to something like
