Total Query from Multiple Tables

J

John VW

I have a number of tables which hold the inception date & policy numbers
sold by each of my staff.

I have created a separate table showing the inception dates I want to
collect data from.

How can I create a query that will use the dates I want and count the
number of policys each person has sold for each day in separate
columns?

ie,

Incep Date/person1/person2/person3
16-02-2004 / 7 / 10 / 9


I have tried building a relationship between the dates I want and the
date field in each of the tables but it doesnt seem to work
 
D

Duane Hookom

I believe a crosstab query will work for you with the date field as the Row
Heading, Person as the Column Heading, and Count of PolicyNumber as the
Value.
 
Top