Recent content by LizSara

<possibly thick moment> What is "ain't" a contraction of? </possibly thick moment> "Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you." ~ Nietzsche"

In the UK at least, we don't have holidays for Halloween or (obv) 4th July or Thanksgiving, so I would suggest that when we say Happy Holidays it's because at Christmas we are actually having a holiday? KG ~ I've definitely never been offended by the phrase Merry Christmas, but I have to say I...

right click on it and do 'Save Sub-report As'. "Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you." ~ Nietzsche"

Are you exporting to excel or excel data only? "Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you." ~ Nietzsche"

The implementation of <existing application name> will not only be considerably cheaper then developing a bespoke system, but will also enable us to begin processing AR Payment imports almost immediately. "Whoever battles with monsters had better see that it does not turn him into a monster...

haven't you got too many following zeroes in your formula compared to your original request? "Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you." ~ Nietzsche"

That looks spot on to me...thank you so much, lots of stars for you "Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you." ~ Nietzsche"

That formula doesn't work. If someone starts on a route on 01/09/2004 and ends on 31/08/2008 they need to be counted in each year, and that doesn't do that. "Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will...

i have the start and end date of when they are on the route "Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you." ~ Nietzsche"

I tried that, the problem was it only put the people in the year that the route started not that year and every subsequent year until their route end date "Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will...

I'm having brain freeze on the best way to do this. I have a crosstab report listing routes as it's rows and giving a count of people on those routes as it's columns. Fairly simple yes? What i need it to do is count how many of those people were on that route per year for the last 5 years...

KornGeek ~ Go ahead, at least people will know you aren't speaking English then rather than having to guess as we do now. "Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you." ~ Nietzsche"

@Korngeek ~ Optional U ~ priceless! "Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you." ~ Nietzsche"

tcsbiz ~ how sad for you "Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you." ~ Nietzsche"

LoLCats are everywhere "Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you." ~ Nietzsche"