Appending data from different tables into a form

[Shimsham]

Hi

I am a "newbie" to Access and need some help.

I have 3 separate tables with the following fields: Year; Name of School; Emis No. (Primary Key); No. wrote; No. passed; Pass %. These tables were imported from Excel.

I would like to do the following: create a form that would allow me to view the all the data per school in datasheet view and also allow me to enter new data annually.

Any advice would be greatly appreciated.

Kind regards

Tony

 

[KingBroil]

Hi, I'm new too, but I will try to help best I can:

First I would create a query that regroup the information you need on your form sorted by school maybe.

You can create a Split Form to have a datasheet and the input form in the same view, very practical.

I hope this gets you a step further.

KingBroil

 

[Shimsham]

Hi KingBroil

Thank you for your assistance. Will try out your suggestion.

Kind regards