Reporting problem-----solved

[chris lynch]

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

[dRAMmer]

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

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

[chris lynch]

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.

[dRAMmer]

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.

[chris lynch]

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

Thanks