Search results

Hi, I have some code that pulls info from a webpage however in order to obtain the rest of the data I need there are a few javascripts that needs to run to update the web data. Below is the table with the "onClick" javascript that runs... <td><div...

Found the issue finally! Within my query one of the fields returned #error due to a division by zero however it never caused issue until now! Once I fixed that it works perfectly again.

The only thing I can think of is that there is a limitation when copying into excel, does anyone know how to get around this?

Tried it on a brand new sheet and tried different cell ranges, same issue. Query still runs perfect manually and on other weeks...?

Anyone got any ideas?

Ok just to give a bit more info on this... I altered the weeks to lower numbers so week 245 became week 12 and it still wont copy over the results of this query (its blank) but its perfectly fine on all weeks before? There is more data in the query results for this week however its still...

Hi, This is an issue that has only appeared this week and I cant figure out why. Below is a snippet of the code that I use, the user is promoters for a week, this has always worked and still does for any number less than 245. I dont know if 246 will work yet as I dont have that data. Is...

Perfect! Just had to change the 2 to a 1 but that you so much

Hi, I have a query that I need to group by Week, however the week is defined as Monday - Sunday. For example the week commencing 10/06/2013 should include 10,11,12,13,14,15 & 16th however from the below query it only returns 10,11,12,13,14 & 15 and the 16th is used as the next week when it...

Hi, I currently have two tables each containing information that I need to complete a query, however the results of suming this information is incorrect. Below is the structure of the table, one contains more fileds than the other however the joins are on the Date and the Name fields. I...

Ok thanks for the reply. I have this working in Excel and im starting to move it to access as running the formulas through Excel is far to slow now. Thanks for the help

Here is some of the data I could use CustTable Area, Location, Name, Satisfaction Scotland, Edinburgh, Chris, 10 Scotland, Edinburgh, Chris, 10 Scotland, Edinburgh, Chris, 7 Scotland, Edinburgh, Chris, 3 Scotland, Perth, James, 2 Scotland, Perth, James, 10 Scotland, Perth, James, 4 Scotland...

Hey guys, Not quite sure how to approach this one but I have a table containing the area, location and name of someone there is also a field contains a number from 0-10. I need to run a query that will count the number of times a number appears in this field and put this total in a field on...