R
Richard
I have db that tracks Active and Inactive customers. I import a text file
every week. I am trying to develop a query that will give me the change in
mumber of Active and Inactive cutomers and the corresponding percentage from
the previous week to the current week. I have a crosstab query that nicely
displays the results, but I have had no luck calculating the change from
record to record. Any help would be greatly appreciated. Thanks.
every week. I am trying to develop a query that will give me the change in
mumber of Active and Inactive cutomers and the corresponding percentage from
the previous week to the current week. I have a crosstab query that nicely
displays the results, but I have had no luck calculating the change from
record to record. Any help would be greatly appreciated. Thanks.