Won't display entire table's contents

[nate_03]

I am trying to create a report that displays data from 2 different tables(Desktop & Department) and have them grouped under a Department Heading. When I create this and run the report 20 or so records do not show up on the report. However, when I try to create a report using only the one table (Desktop) all of the records are displayed. There are'nt any duplicate records of course. Am I missing something?

Thanks for any help in advance,

Nate

 

[Fuga]

Can you give a little more information on your table structure?

Fuga.

 

[nate_03]

Sure,

Desktop Table contains 9 Columns:

Computer_Name
User_Name
Make/Model
HD_Mem
RAM
Processor
Invoice_Date
Invoice_Amount
Serial_Number

Department Table contains 2 Columns:

Dept_Name
Dept_ID

Again I am trying to create a report with Dept_Name as the heading and have all the data in Desktop grouped according to Dept_Name.

How is the weather in Sweden now? Toronto, Canada is 20C right now!

 

[Fuga]

Are you basing your report on a query from the two tables? If so, have you checked the joins etc?

It´s a typical swedish summer. Rain & cold winds

Fuga.