Reply to thread

Message: [QUOTE="Geel, post: 991402"] Hello, Im busy on a project that's building reports out of entry's in an access system. 'The data is build on some different levels. Savings_ID Contract_ID Department_ID Total Now i did a left join that will show all the data in the department ID ( even if savings and contract are empty ). This is what i want and im very pleased it's working. But now i've got a new problem. Because of the left join empty fields show up, wich is what i want. But the fields are showing on top of the query. Making the report read empty fields where there should actually be data. For instance the report_name should be shown but because of this field being empty in the first record showing, it's showing an empty field. Is there any simple workaround or IFF statement wich can help me out ? Thanks a lot, Tim [/QUOTE]