I'm pretty new to Access so I'm not sure this is even possible. My goal is to create a form that enables users to filter data (using one or more criteria) and create a custom report.
I created a report that has college students' names, student year, the subject they are enrolled in, and a grade for that subject. All this data is coming from a separate query and each student has one row and one class. My report has about 300 rows (1 for each student) but I want to allow users to view fewer results in the report based on specific categories in the query. For example, it would be great if a user can use a form to select one or more subjects and just view a report for students enrolled in English and Math.
I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro: