Type Mismatch? on exporting to excel

[hartbros]

I have a date range report that pulls from a few critera one of the critera is servce tech I have about 6 Service techs I pull on it works on all but me i put in the start date and end date and my name and I get a Type Mismatch when it is calulating iny ideas thanks in advance Justin

 

[koresnordic]

sounds like it might be trying to calculate on a numerical field. Have a look at your numerical fileds and see if any are blank as this could cause this problem.



Graham

 

[hartbros]

the field is a text field and it works when I look up diffent stuff for example it is doing first of all date range, then by tech for ie BA, or LR, Or JWH it works on the first 2 but not on JWH????? crazy.. any other ideas