Peter J. Boettcher — Mon, 20 Aug 2001 12:34:30 +0000

It's probably doing that because you're not using a stored procedure, try taking that line, and everything up to and including "SET NOCOUNT ON" out.

a_gajic — Sun, 19 Aug 2001 18:13:27 +0000

thanks a lot peter your help was greatly appreciated

-----

I get an error and it highlight the word PROCEDURE on line 1..?

Peter J. Boettcher — Wed, 15 Aug 2001 17:11:20 +0000

Adam,

Search queries can become pretty complex, I'll try to keep it simple. Here's a sample stored procedure using your fields.

CREATE PROCEDURE dbo.CarSearch

@Manufacturer varchar(50),
@Registration varchar(50),
@Fuel varchar(20),
@MileageLow integer,
@MileageHigh integer,
@State varchar(50),
@PriceLow money,
@PriceHigh money

SET NOCOUNT ON

SELECT * FROM TBL_Second_Use_Cars
WHERE Manufacturer = @Manufacturer
AND Registration_Letter LIKE @Registration + '_'
AND Petrol/Diesel = @Fuel
AND Mileage BETWEEN @MileageLow AND @MileageHigh
AND Price BETWEEN @PriceLow AND @PriceHigh

You will have to modify this a little to work with Access but you should be able to see the logic from this example.

P.S. You should really have a separate table for the manufacturers, and then link that table to your existing table.