Oddity with ADODB

[RichardMGreen]

Hi all

I've got an Access database with a load of queries that I'm using Excel to run.

One query is causing me a bit of a headache. It's basically desinged to give me 4 numbers so I can do calculations in Excel.
In the database, it brings back:-
41,254,53,648.

When I use Excel to bring it back (using the same parameter) it brings back:-
34,254,42,648

The numbers are for monthly signed-off, monthly total, year to date signed-off and year to date total.

I can't really post any data because it's confidential but I can post the queries if necessary.

Anyone any ideas to point me in the right direction?

 

[RichardMGreen]

Ignore me, I'm an idiot.
I'm using * as a wildcard in Access but forgot to put the option of % in because it ADO.

Solved it.