Re: sql help
Posted in 1996
> When I run a report using the following select statement, the data from at > lest one customer id does not show up. > [SNIP] > > I do not understand why this happens since I am adding another criteria > and not substituting. Have you checked/repaired your indexes lately? Also, could we have more info? Engine/version, OS/version, hardware, front end tool/version? Breathlessly awaiting your reply... :-) -- Ciao, Billy +----------------------------------------------------------------------+ | Billy Wheeler Chief Cook & Bottlewasher The West Solutions Group | +----------------------------------------------------------------------+ | (E) billy@west.co.za (U) http://www.west.co.za (W) +27118032151 | +----------------------------------------------------------------------+