Search results

Morning, The query has been running for 4hrs so far with no signs of being close to completion. :( Does this seem a normal time for this particular code? The source data table only contains 6000 rows of data and 3 columns. Attached is exactly how I would resolve this query using Excel...

Thanks again Arnel! I have a meeting to go to now but I will report back tomorrow to let you know how i get on. Much appreciated.

Hi Arnel, Thank you for all your help, I greatly appreciate it!! I have looked into your code and I think I am happy with everything that it is doing, I have amended it to run against my live DB and the query runs fine for a short while before I am presented with the following error: "AT...

Hi Arnel, I will study the module and see if I can get it to work with my db. Thanks again.

Hi Ranman, Thanks for your reply. I have tried a crosstab qry but to no avail. :(

Hi Arnel, Thanks for your reply. API will always be the first status but from then on wards the second status can literally be anything, yes. So it could be Status 1 Status 2 Status 3 API NLP COM etc. up to approx 30 statuses in some cases.

Hi, I still consider myself a novice with Access having only been using it properly for around 6 months but I've always been able to solve everything without directly requesting assistance. E.g by using google / the forums, that was until now.. My issue is this. I have a data table...