Tabular form

[Guest]

LS,

I have a table which contains columns containing dates, contain number and
text. For example:
Date Number Text
01-01-2005 1 First
02-01-2005 7 Second
03-01-2006 10 First
.....

I have created a query selecting a period of time. Now based on this query I
try to create a form which has the dates in the headings area and the text in
the row are, somewhat like this.
01-01-2005 02-01-2005 03-01-2005 Total
First 1 10
11
Second 7
7

Is this possible in a form? I know I can use pivottable, however I do not
want to use this.

TIA

 

[Linda Burnside]

Create a query which will will sum number and group on Text. Join the query
to your table. Then you can display the summed total along with the
individual date detail.

Linda