Thanks Jonathan that was exactly what I was trying to do

🙂

Hi Happygeek,

Thanks for that. It worked like a charm.

Regards
Chris

Not sure how to do what you suggested, But I did download the returned values to excel and the entries that are showing that date are being downloaded as -53689....

How do I find the datatype. I am only assuming it is a date as that is what the field show be on our system?

I assume there...

At the moment just the field it is pulling from, I have tried a few expressions that haven't worked I am getting 1/1/1753 12:00:00AM returned but I know the box...

I have had a thought though is there a way i can create a dynamic calculated field that in my head would look something like =sumif(and("for each fee earner change",Where...

Thanks MMartin. Sadly that went right over my head. Sorry im very green at SQL reporting 🙁

Point taken Happygeek. Thanks for the advice.

Hi Thom

This is below what I am trying to achieve with my report. This is a spreadsheet that we currently update manually but I am trying to automate...

The total for the year to date is data. When I do grouping to show totals the grouping doesnt show the year target total which is why i thought it...

Hi Thom

Thanks for the reply, I would have done that but one of the items in the data is a total pulled from the server and it multiples...

Thanks again Happygeek

So how would I add that to the query already running. I assume it isnt a simple copy and paste at the end of this?

Wow just read that and I am not going to lie, that went way over my head. I wouldn't even know where to begin with code like that or where...

Hi Sue

Sorry my error, I should have proof read it before posting it. It made sense in my head before i typed it

Maybe its better...

Thanks David and Thom A both your input has been most appreciated.

Using individual criteria on each report is working well but a couple of tables seem to be...