referring problem

carelfly

Registered User.
Local time
Today, 08:24
Joined
Sep 23, 2010
Messages
13
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
 
You probably need a crosstab query.
 

Users who are viewing this thread

Back
Top Bottom