[AccessD] Create a Search

Gustav Brock gustav at cactus.dk
Fri Jul 30 08:10:32 CDT 2004


Hi Virginia

This AddToWhere function should get you started:

  http://www.tek-tips.com/gfaqs.cfm/lev2/4/lev3/27/pid/702/fid/1177

You will need to refine it for date filtering. Just remember to
specify any date/time as a String using the Lembit method:

<code>

Public Function StrDateSQL(ByVal dat As Date) As String

' Formats full string of date/time in US format for SQL.
' Overrides local (non US) settings for date/time separators.
' Example output:
'
'   #08/16/1998 04:03:36 PM#
'
' 1999-10-21. Cactus Data ApS, CPH.

  StrDateSQL = Format(dat, "\#mm\/dd\/yyyy hh\:nn\:ss AM/PM\#")

End Function

</code>

/gustav


> There are only a few fields they want to search and create the report from.
> Around 7 fields and a date field.
 
> Virginia
> ************
 
> Virginia, in truth this in an ambitious project. Do they want to search any
> field or can you restrict that much? 
 
> Susan H. 
 
> Does anyone have an example of creating a report by selecting search
> criteria from fields? I had a request today to add a custom report builder
> to one of my databases.




More information about the AccessD mailing list