Problem with reports, help rqd pleade.

[Guest_imported]

Hello all,

I am having a slight problem with my reports on my database.

When I want to compile a report of items with say the word 'orange' in them, it only compiles the report with items that BEGIN with the word 'orange'. It does not list those items that have the word orange at some other point in the text, only at the beginning.

Could someone help me out with this.

Thanks in advance

Mark.

 

[edge2000]

Hi Mark

I assume you are using a query for the basis of the report and have something like,

Select * From MyTable Where Colour Like "Orange*"

If you want records that contain orange the statement should be

Select * From MyTable Where Colour Like "*Orange*"

This looks for text either side of the word orange, the first statement would also only work if orange was the first word so I beleive.

Cheers Dave






Dave
dab@completebs.com

http://www.completebs.com

See website for more info but we can develop most things for most people.