I'm building my first query in Access - need help

[Kurrupt]

i work at an elementary school and they asked if the following can be done:

basically a query/form has to be created of monthly student suspensions and
all.

so you'd have a form (visualize this) with the order:

1.
2.
3.
4.
etc

across you would have the following:

no.
date.
name.
grade
sex
ethnic group
offense a-k
disciplinary action 1-6
1-5 days
# of suspensions this year
total suspensions
project hope
others

--------------------

now the key is for to input data of each student and all corresponding
information. should repeat students make the same infractions, it'd be easy
to pull that file and add on.

at the end of each month , this query can generate a report of what kids
have screwed up for the month of x.

So I"m looking through the access walkthrough. It doesn't seem confusing but a bit overwhelming. Anyone got any ideas on how to work this through? thx

 

[BuckleDownBen]

Do you already have the data you need to report on in tables? If not, then you'll need to make the tables. If so, maybe you vould post the table structures.

 

[EagleKeeper]

Your description across contains the field names that you wish to use in your primary table
You will need some as numeric, some as string and date.

You may wish to have additional tables for the offense list and the disciplinary action list.

Your query will ask for the month # and generate a list of students.
Access has simple query builders to set it up for you.