Reporting problem-----solved

I ahve three linked tables, studentnames, classnames and attendance. The studentnames and classnames are linked to the attendance table using the ID numbers(primary keys). When making a new report for the attendance table is it possible to have the actual names of students and classes appear in the report rather then the numbers linking them?

if not is there any good way of getting around this

Yes it is you should have a query (where your report gets its data) like:

Code:

---

SELECT a.ID, a.somefields, s.StudentName, c.ClassName
FROM Attendance a JOIN Students s ON s.Code = a.StudentCode
JOIN Classes c ON c.Code = a.ClassCode
optional where clause

---

you'll have to bear with me now. this is first time using access, doi make the query with the query wizard and where do i put the code.. Can you help a little more please.

I'm not using Access anymore. But there's a new button there and after you click it, a "New Query" window will appear. Choose Design View, then click Close and click View (on the main menu) then SQL View. Then you can type your query there. or paste the code I suggested and edit it base on your table/fields name. Let me know if you need more help.

I made a query without the code, its all the same is it? I just filled in the fields in the design view

Thanks