RE: Month/Year Queries

2003-07-21 Thread Matthew Walker
's bit hard on the eyes. I like your existing solution better. > -Original Message- > From: Jim McAtee [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 22 July 2003 9:57 a.m. > To: CF-Talk > Subject: Month/Year Queries > > I've got a table with 'year

Month/Year Queries

2003-07-21 Thread Jim McAtee
I've got a table with 'year' and 'month' columns used to track quantities (of widgets sold, doughnuts eaten - doesn't really matter) for certain objects in a given month. The reason that only monthly totals are kept instead of creating a record for every transaction is that the table would otherw