I have an access database. The users would like to be able to search on any one of the fields. Plus, they would like to search on the fields within a date range, and have one of the fields added up when the results are shown. For example, a user will search the location field for a specific location during the the month of January. The results will show all records with the searched location for that month, and the bottom of the list will have totaled up the manhours for the records returned. My first instict was to build a seperate query statement for each field to search. It will check if the field id blank, and if not, perform the search. However, I get the followinf error. HTTP Error 405 405 Method Not Allowed The method specified in the Request Line is not allowed for the resource identified by the request. Please ensure that you have the proper MIME type set up for the resource you are requesting. Please contact the server's administrator if this problem persists. Any guidance? I can send code to those who want to see it. Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
