Search results

Thanks Tim, I cut and pasted the sql, now I get a syntax error Any Ideas Thanks Geoff

I have the following code but it just won't work DoCmd.RunSQL "INSERT INTO CBUDPresG ( Utility_Type, Month, Period, SumOfCost" & _ "SELECT [Central_Budget_Utilities_Data_(Present)].Utility_Type, [Central_Budget_Utilities_Data_(Present)].Period AS Month...

I've tried every thing but can't get it to work, this is the data I am creating my chart with and I want a seperate chart for each utility, but what ever I do I keep on getting a combined chart. Utility Month Period Pres Prev Electricity Sep 200209...

I've also attached this as a word doc as it is easier to follow I have the following Tables Table 1 Utility_Type RunningSum Month Oil £3,342.43 Sep Oil -£42,441.32 Nov Table 2 Utility_Type RunningSum Month Oil £3,505.62 Oct Oil...

I have the following query DELETE CBUDPresG.* FROM CBUDPresG; Which I would like to run in VBA as a RunSQL command, as I have quite a few of these queries and thought it would be neater, but I haven't got a clue where to start. Any help appreciated Thanks Geoff

I have a table with the Field Invoice_Date as dd/mm/yyyy, I want this shown in a query as mmyyyy so I can group by the month Invoice_Period: Format(DateAdd("d",5,[Date_TaxPoint]),"mmyyyy") It displays it fine but in a text format which I can't sort on as 012001 come before 062000 anyone have...

I have the following formula which I just can't get to work the Point_Id is a Numeric field and the Date field is a Date Field Dlookup("[M1_Present]","DataElectricity","[Point_Id] = '" & [Points].[Id] & "' And [Date] = #" & [Date] & "#")) Any help would be greatly appreciated Thanks Geoff