Thread: Sum in Query in microsoft.public.access.adp.sqlserver

  Hello again, I'm still finding may way here with Access ADP and SQL queries. I was going along at a clip writing simple queries. My First one was to total Vacation Balance in 2009: SELECT LADOLFO.Combination.EMPLID, LADOLFO.Combination.NAME, LADOLFO.[2009 Vacation Balance].[Vacation Balance] FROM LADOLFO.[2009 Vacation Balance] CROSS JOIN LADOLFO.Combination Worked just fine. My Second was Total all Vacation Earned: SELECT...

  If you are using some sort of graphical designer for building your queries -- don't! These graphical designers can only build very simple statements and will likely fail for something like your current query. Second, when you see things like [2009 Vacation Balance] and ([Vacation Hours Used 1] ... ([Vacation Hours Used 10], it make your design very suspicious about a total lack of normalisation. Before going any further, you...