Crosstab

[Guest]

Hi everyone,
I have a qry that includes Client, Year, and then about 20 more fields
of mostly dates. What I would like to set up is a cross tab that would show
each client and year as rows then show me for each client and year which of
the other fields is null.
Ideas?

Thanks.

 

[Guest]

What you have is a spreadsheet. You can not make a crosstab query from that.
You need to change your table structure to something like this --
Client
EventDate
Event

Then you can extract the year from the date field when you need it. You can
use a union query to make a new table of your current data.