referring problem

[carelfly]

I have a table in a database that allows input of customers and a referring customer. it also has a checkbox to allow the customer to be used in the report. each referring customer is taken from a lookup list of current customer stored in a separate table(created by a query). i need to make a report that will give me :|customer|refcustomer1|refcustomer2|refcustomer3|recustomer4|
can anyone point me in the right direction

 

[Galaxiom]

You probably need a crosstab query.