Search results

Thanks however this is still throwing up an error! Sorry I may not have explained myself properly (and I might still be doing it wrong!) The table which the data is coming from is stored in another database. The idea is to create a temporary table in which the user can decide whether to update...

Hello :) I am trying to use SQL to run queries in our access database in order to (hopefully) speed things up. I'm trying to create code that basically takes data from one table and inserts it into another whilst doing calculations on the data. However I can't get past this...

joh024 - thanks I will have a play with this and see if I can make it work. HiTechCoach - this looks very interesting many thanks for posting this I may be able to use it. Steph

I would have the kWh as the value - but to add the dashes in would require an IIf statement or a second field with the start date in, but in order to get that to display in the correct place it would also need to be sorted by values else it would be another column and would make no sense. The...

I tried this, the problem with that was whilst I could get the data to display correctly I couldn't add the dashes in because I can't group more than one thing by value (I spent hours trying to work out a code that worked) so I thought I would try a form instead which apparently has a tad more...

Yes they are

Okay before the nitty gritty code part I shall try and explain what I am trying to acheive! I am trying to make a form that will display the 'kWh' used per month per site. I have a table of data from suppliers that details the amount used, the start date of the bill and the end date of the...