Tabular form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top