Complex Queries to run off a button

[jaarons]

Ok here's something I want to do.



I am a teacher, and in my class database I have a table called anecdotals (for my anecdotal notes). I have a form that I can enter date, subject, student (from a pull down) and notes. It then gets entered into my Anecdotal table.

What I want is to create queries that I can link to a menu button that will allow the user to:
1) Create a report of all anecdotal notes about a particular student, according to subject (ie: Filter all results in Anecdotal table to only those about Billy and pertaining to Math)
2) Create a report of all anecdotal notes about a particular student, according to terms (ie: Filter all results in Anecdotal table to only those about Billy and pertaining to Term whatever and then grouping by subject)

The second option needs me to define for access the exact dates for terms 1, 2, 3 & 4.

Any ideas? Please help!

[June7]

See if this gives you some ideas http://datapigtechnologies.com/flash...mtoreport.html

[jaarons]

Ok, no it's not helping. It's making my head hurt. Aside from what I said in my previous post, this is what I have done.
1) Created a table called Terms2013 where I have Term Name, Date1, Date2 (where the term is inside those dates). I have a record for each of the four terms.
2) I have a basic form set up with a combo box that links to the term name field of that table. I then created a button to run the query, thereby run a report, but that's where I got stuck. Of course I haven't set up the query yet and the whole thing is just hurting my head.

What can I do?

[June7]

Do you have a table that relates student with a term?

Really can't help without knowing your data structure. Need to get your data structure correct before even think about building forms and reports. Review 'sticky' thread tutorials at http://forums.aspfree.com/microsoft-access-help-18/

Have you looked at Microsoft template databases? A selection is available when you open Access, even a couple for student records.

[ssanfu]

You don't need to open a query before opening a report.

Rather than write out step-by-step, look a the attached mdb. Is this close to what you want?

[jaarons]

Thank you so much, ssanfu! That worked an absolute treat! I had to tinker with it for a while to make it fit with my database, but thank you VERY much for taking the time!

[ssanfu]

Glad you got it to work