Select * from tbldocuments where (instr(Filename,'#form.fFileName#')>0) where and (instr(Author,'#form.fAuthor#')>0) where and (CreationDate > #pd##vdateStart##pd#) where and (CreationDate < #pd##vdateEnd##pd#) where and (instr(Keywords,'#form.fKeyword1#')>0) and (instr(Keywords,'#form.fKeyword2#')>0) and (instr(Keywords,'#form.fKeyword3#')>0) and (instr(Keywords,'#form.fKeyword4#')>0) ;
  Search Results  Search Again
Home

#results.recordcount# records found.

#Title#

Filename: #filename#
Creation Date: #dateformat(CreationDate,"mmm dd,yyyy")#
Author: #Author#
Size: #Size# bytes
File Format: #FileFormat#
Keywords: #theKeywords#
Model Set Name: #ModelSetName#
Group Name: #GroupName#
Recommended Plots Style: #RecommendedPlotsStyle#
Software Used: #SoftwareUsed#
Comments: #Comments#

Click here to download this file