I'm sure I'm missing the obvious reading through faq 701-4230 & the numerous other date posts here but for the life of me my brain isn't getting it.
I have a table where all 52 weeks of the year are accounted for Sun-Sat for expample. In the table there is a record for week 4
which is defined by 2 fields
begweek :02/25/2007
endofweek :03/03/2007.
I'm trying to pull data from a sales table for that range only. The sales table has the date information in it but I'm stumped as to how to basically do something that says
Sum up the sales when the sales date is between beg & end of week 4.
I'm sure this is simple but it's got my brain frazzled.
Thanks in advance.
gina
I have a table where all 52 weeks of the year are accounted for Sun-Sat for expample. In the table there is a record for week 4
which is defined by 2 fields
begweek :02/25/2007
endofweek :03/03/2007.
I'm trying to pull data from a sales table for that range only. The sales table has the date information in it but I'm stumped as to how to basically do something that says
Sum up the sales when the sales date is between beg & end of week 4.
I'm sure this is simple but it's got my brain frazzled.
Thanks in advance.
gina