Hi,
Thanks for yout help, but i am getting an name error.
I posted the formula again, maybe i am missing a comma or somthing
When you get a chance, take a look at it for me. Also i am typing this code in the control source of a textbox, is that correct? Thanks
SELECT...
Thanks for your help, but i have another question for you, maybe we can implement your formula in this function. I have a tabe that lists Mailer, and Runtype, I would like to count the unique mailers, that have the Run Type CD, LR, and RU.
I used the following Formula...
Hi,
I have a report that lists Mailers, and i would like to count the unique mailers. For Example,
Mailer
Mark
Mark
Tom
Total number of mailers = 2, is there a formula that can count in this fashion. Thanks in advance
Bob,
I made the necessary changes you specified and i am still getting an error. It is saying Runtime error 13, Type mismatch. If you have any other suggestions, let me know. Thanks for your help.
Stephen
Dale,
Thanks for your help, but the results of the sort is not what i wanted. I would like to sort if possible first by month, and then by week. When I tried it your way this is what result I got, maybe I missed a step. It looks like, it only lets you do one custom sort at a time. For...
Is there a way to do two custom sorts. For Example, I have a column headings called Months, and week. The option does not let me sort by Months and then by Week. I am sure there is a way. Thanks
Mark
I have an Access report that hasa date field. The Month is a field.. I have the report grouped by name. I would like to sort first by name and then by the Month field. For Example:
Name Month
Tom Oct
July
Jan
Mark Month...
Is there a way in the Crosstab query to select a fiscal year period. All I see is year, months, ect. When I choose year it does not Format the right dates. For example,
The Fiscal year period is November-October, and i want to compare 3 years. And I want the column headings to be...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.