Need Help about students record

[edesign]

Hi Everyone!


I have created database for students.
I have two tables.One for stduent record other for cities.
I want to search database based on cities.
and print report regarding students.i.e print all students who are from 'New York'. etc

Please help me regarding this.
I have attached sample DB.

[orange]

What exactly is your question? What do you need help with?

[edesign]

What exactly is your question? What do you need help with?

My question is "what query should i apply to print report regarding each city? i have many cities like New York, Washington etc"
I want to print how many students are from New York,Washington etc on different reports.

[orange]

You have no student data in your database.
Suggest you look at finding the info you want with a query first.


This should give you a count of Students per City.

SELECT Count(Students.StdName) AS CountOfStdName, Students.City
FROM Students
GROUP BY Students.City
ORDER BY Students.City;

You may find more info on Group By at http://www.3schools.com

[edesign]

Thanks @Orange
how can i generate report in access based on query

[orange]

Have you tried using the Report Wizard with your Students table?

Reports have their own sorting and grouping, so working with the table should be fine.

[Daryl2106]

Hi,

I am only a beginner too but I am also working on a student DB. I think what you are trying to do is enter the city for each student record. To do that you'll need to add a city field to the Students table. Also, I have created a relationship between the two tables. I am not sure how familiar you are with Access, but I suggest opening up the tables and looking at the settings. There are so many little things about Access that the best way to learn is by coping your existing DB and then playing with it. This forum is great, there are alot of great people here how have helped me tremendously. Asl lots of questions.

I would like someone else to maybe have a look to see if what I've doen/suggested is okay. This is my first ever reply to a post.

Take care,

Daryl

Update DB attached

[ssanfu]

I would like someone else to maybe have a look to see if what I've doen/suggested is okay.

The only things I would suggest is:

1) Object names should only contain letters, numbers and/or the underscore. No special characters......
2) Fields like zip codes, Phone numbers, SSNs should be a text type, not number. If you plan on doing calculations, the field should be number type.



My $0.02.....

[edesign]

Thanks @Daryl2106 and @ ssanfu