Search results

I am trying to create a query which shows the one yers rates against the others side by side. ie 31/01/02 5p 31/01/03 5.5p I am geting the data from one table which is a continuous list of month and rate. I tried the following query SELECT...

thanks brian, you are a star thanks geoff

When I change it to an update query and try and run I get the error 'Format([Time],'nn')' is not a valid name, make sure it does not include invalid characters or punctuation and that it is not too long. Any ideas Thanks Geoff

Thanks very much, works a treat Geoff

I am using the following code to delete a group of temporary tables, when a particular form is closed, the problem I am having is that not all the tables will exist. When a table doesn't exist the code stops running and the remaing tables are not deleted. I need a way to loop through until all...

Hi there, I have a table of data which contains a time field which I need to update, I have created a select query to find the records that need updating SELECT Format([Time],'nn') AS [Minute] FROM tblFlexima_Profile_Data WHERE (((Format([Time],'nn')) Between '16' And '45' And Not...

I am still having problems, when I delete a record from the subform it is deleting it from the lookup table rather than just groups table as well as the table tblAggregation_Site_Details. which I do not want to happen. I need it to be made available again for adding to an alternative site...

I have a db (attached), which contains a form and a sub form on the subform you select a location from a combo box, this is then related to the site of the main form. The problem I am having is that the other 2 fields are not populating themselves until I move to another record then back again...

I've included a sample db with the two tables and the query associated with them, if someone could have a look that would be great Thanks Geoff

Hi there again guys I made the changes as suggested but now I am getting a syntax error DoCmd.RunSQL ("INSERT INTO [tblDirect_Data_All_Utilities_(Apportioned)] ( Id, [Month], Apportioned, CO2 ) " _ & "SELECT [Points].[Id], DateAdd('d',-1,DateAdd(m,1,'01/' &...

I have the following query SELECT Points.Id, DateAdd("d",-1,DateAdd("m",1,"01/" & Format(DateAdd("d",-15,[Date]),"mm/yyyy"))) AS [Month], DataWater.Units, Int(([DataWater].[Units]/([Date]-(DateAdd("d",0,DMax("[Date]","DataWater","[Point_Id] = " & [Points].[Id] & " And [Direct] = 'D' And [Date]...

Thanks Sue, That works a charm, I knew it had to be something simple Thanks Geoff

Thanks sue, silly old me thanks geoff

I have the following code DoCmd.RunSQL ("INSERT INTO [tblDirect_Data_All_Utilities_(Apportioned)] ( Id, [Month], Apportioned, CO2 ) " _ & "SELECT [Points].[Id], DateAdd("d",-1,DateAdd(m,1,"01/" & Format(DateAdd("d",-15,[Date]),"mm/yyyy"))) AS [Month], " _ &...

thanks now works a treat Geoff

Hi there, I have a report included in the attached db which has a field TotalUnits, and a calculation average of total units. I have set conditional formating to red and bold total units where it is more than 10% higher than average total units. But this doesn't seem to work as expected any...

i can't change them, it runs fin as a query, i just want to get rid of some of the smaller queries to clean things up a bit thanks geoff

Hi there, I'm trying to get the following to work but i'm having syntax problems DoCmd.RunSQL ("INSERT INTO [tblSatchwell_Trend_Logs_(Data)] ( Point_ID, [Date], [Time], Reading )" _ & "SELECT Points.Id AS Point_ID, [tblSatchwell_Trend_Logs_(Temp)].Date, [tblSatchwell_Trend_Logs_(Temp)].Time...

Hi there, I've searched the help files but I'm still struggling to find anything relevent, could you cut and paste a sample from your help files Thanks Geoff

thanks for the reply, but i'm not sure what you mean thanks geoff