Searching between 2 fields

[rissac]

I'm developing a search page for my database and I need to find the results between two field options. I seem to be getting an error every time I want to search for the results. I am using Dreamweaver for asp development. Does anyone have any recommendations? Error below.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Client.client_ID 14 AND job_act = 'active''.


Link to record set is below.

http://www.ninaplastics.com/temp/RecordSet.asp

 

[JamesLean]

I would recommend you post this either in the ASP forum or one of the Access forums. But just as a starter, you probably want that to read:

Client.client_ID = 14 AND job_act = 'active'

--James