Thank you all for your responses. The month field is a date field in format mmm-yy, and the sql is as follows: SELECT tblRMB520.ProductGroup, tblRMB520.[State Name], tblRMB520.Month, Sum(tblRMB520.WU) AS Units FROM tblRMB520 GROUP BY tblRMB520.ProductGroup, tblRMB520.[State Name], tblRMB520.Month; I would like to group by moving 3 month periods so that I will have data grouped for the
I have the following: ------------------------------ 1. Stock driver's seat and rear pillon (passenger cushion/seat) for 2004 VSTAR 1100 Classic Silverado. Perfect condition. Both together, $150. The seat and pillon have the Silverado silver studs on them. 2. These are the stock pipes that were replaced after barely a couple of hundred miles. Complete with both pipes. $200. Fits 2004 VSTAR
Tom J wrote: peter wrote: Agreed. Many of the "campgrounds" listed near my home are actually the private homes of people involved in operating various summer camp programs (bible camps, scout camps, etc.). They really wouldn't appreciate having people pull up in their driveway with an RV or having people start setting up tents in their backyard. Apparently
Frank, Row source query is: SELECT Products.Description, Products.Unit, Products.ProdID, IIf(Val([Unit])=0,1,Val([Unit])) AS Expr1, Products.ProductGroup FROM Products WHERE (((Products.ProductGroup)<>"S" And (Products.ProductGroup)<>"B" And (Products.ProductGroup)<>"EQ")) ORDER BY Products.Description; Combo setup: Give the combo 3 columns and make column(2) the bound column
Greg O wrote: "Andy aka Big Stinkie" <andythe@earthlink.net> wrote in message news:47d5c52b$1@127.0.0.1... Greg O wrote: "Andy the" <andythe@earthlink.net> wrote in message news:13tbbo82q7i0p82@corp.supernews.com... James Poe wrote: Sposta be 65 here in kc tomorrow. I'm trying to remember what that's like. Yep...that's where I live
