On Thu, 7 Apr 2005 13:59:06 -0700, xopher
wrote:
My static table is set up as follows:
Acct#, Time_Period_1 (Sunday 3-6), Time_Period_2 (Sunday 6-9), etc.
123456, 45, , 60, ,
etc.
456789 60, , 58, ,
etc.
Sorry... that's not a table. That's a spreadsheet.
Storing data (dates) in a fieldname makes it very difficult to create
appropriate queries. That's why you're having trouble: your table
design is not normalized; queries work best with normalized tables.
Any chance you could normalize this into a tall-thin table with three
fields, AcctNo (don't use # in fieldnames), TimePeriod, and Amount?
This would make your query vastly easier.
John W. Vinson[MVP]
|