Crosstab Report

[Nick 'The Database Guy']

Hello,

I am trying to create a report based on a crosstab query, with name
down the left hand side and date going along the top, the first
difficulty that I am having, which really is to do with the query, is
that if there has been no activity for that day there is no entry, so
my first question is, does anyone know a way of forcing a blank result
so that all the days are included? My second challenge is to add two
totals columns (one horizontal, one vertical) which I do not seem able
to do through VBA code. I am changing the labels to display the
correct field name and the assign data to the textboxes. So its just
these two things that I am stuck on.

Many thanks in advance,

Nick

 

[Nick 'The Database Guy']

Hello,

I am trying to create a report based on a crosstab query, with name
down the left hand side and date going along the top, the first
difficulty that I am having, which really is to do with the query, is
that if there has been no activity for that day there is no entry, so
my first question is, does anyone know a way of forcing a blank result
so that all the days are included?  My second challenge is to add two
totals columns (one horizontal, one vertical) which I do not seem able
to do through VBA code.  I am changing the labels to display the
correct field name and the assign data to the textboxes.  So its just
these two things that I am stuck on.

Many thanks in advance,

Nick

Well the first part I have solved quite simply by creating another
table with the next two weeks worth of dates in, adding it to the
cross-tab query and then using a left handed join.