Hi all,
I have been struggling for a few days to build a functioning query. I actually managed to make it work for a smaller set of data but I'm using the following function:
RankOfDup: (SELECT Count(*) FROM
WHERE [field1]=
.[field1] And [field2] >=
.[field2])
which I believe slows my query, if I do select query it runs for around 2 minutes but if I try to make table it never executes.
The reason I need make query is that after this I need to create Crosstab query that basically turns the ranks from rows into columns. I tried to create the crosstab using the select query with the RankOfDub but it gives an error that the the database doesn't recognise a field.
Any ideas how I can make this work for large set of data, ie rank the rows and turn them into crosstab?
If anything is unclear please ask questions and I will explain.
Thank you very much, I hope someone can help!
I have been struggling for a few days to build a functioning query. I actually managed to make it work for a smaller set of data but I'm using the following function:
RankOfDup: (SELECT Count(*) FROM
which I believe slows my query, if I do select query it runs for around 2 minutes but if I try to make table it never executes.
The reason I need make query is that after this I need to create Crosstab query that basically turns the ranks from rows into columns. I tried to create the crosstab using the select query with the RankOfDub but it gives an error that the the database doesn't recognise a field.
Any ideas how I can make this work for large set of data, ie rank the rows and turn them into crosstab?
If anything is unclear please ask questions and I will explain.
Thank you very much, I hope someone can help!