Strcmp problems (1 Viewer)

[reek_99]

I have a situation here. I have a query that was made in Access that works perfectly fine when I create a report from it. When I use the same information from that query and try to design a report in Crystal reports 11 i get no information back. Now, get this, I get the result I want on all of the fields that I run in CR11 but this one particualar field I do not get any results from. The only difference is the data. For instance the field that will not run is "B001" and all the other fields are "ABC," "DEF", and so on. The field is 8 char; alpha. It does not makes sense that all the other fields work and this one field will not give me any results. Please advise or help or something. It has been racking my brain for 4 days now.

 

[Mile-O]

Well, what code are you using? Always best to give as much information otherwise people start assuming, which is never good.