When you say doesn't run do you mean nothing happens or that it craps out in the middle. Have you run it in debug and seen which line it stops on? "GuiGuy via AccessMonster.com" <u14898@uwe> wrote in message news:8466a3c6f91fd@uwe... Can anyone tell me why the code listed does not run from a comand button when clicked? I have copied the query code and modified it so as to replace
John, My client wanted a report to look at his customer sales for the previous year with a column for the current selected month. So the if the user selected May 2008 the end result would be: Customer SalesMay2007 SalesJun2007 SalesJul2007... to SalesApr2008 SalesMay2008 Joe & Co $1000.00 $2589.01 $153.00 $1545.98 $1201.77
Hello, I don't know if I can explain this properly, but I have a form with two textboxes, [selectMonth] and [selectYear], which are Integers. The underlying table has sets of fields, [Mo12] [Year12] [Sales12] ... to ... [Mo1] [Year1] [Sales1] I have a SOURCE table with fields [Month] [Year] [Sales] which will be directed to the pertinent fields in the form's table according to
Return-Path: <chance2008@gmf1.de> Received: from cg-p07-fb.rzone.de (cg-p07-fb.rzone.de [81.169.146.215]) by tarpit2.thrush.com (8.14.1/8.14.1) with ESMTP id lB8A3ELN006361 for <spamvictim@target.site>; Sat, 8 Dec 2007 05:03:16 -0500 (EST) Received: from mo-p00-ob.rzone.de (fruni-mo-p00-ob.mail [192.168.63.71]) by gibbsson-fb-02.store (RZmta 14.0) with ESMTP id r001ffjB895AV6 for <spamvictim@target