Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. compufreaks

    min and max dates

    hi i have managed to sort this issue out ... here is the solution strSQL = strSQL & " WHERE [Clusters].Cluster_Desc='" & [Combo1] & "' AND Source.Day_Month_Year Between #" & DMax("Day_Month_Year", "Source") & "# AND #" & DMin("Day_Month_Year", "Source") & "#;" thanks again for all your help
  2. compufreaks

    min and max dates

    hi there thanks for your reply :) i have made some progress with this issue just having this error , its a runtime 3075 error strSQL = strSQL & " " & "WHERE [Clusters].Cluster_Desc =" & [Combo1] & " and " & "Source.Day_Month_Year Between #" & DMax("Day_Month_Year", "Source") & "# AND #" &...
  3. compufreaks

    min and max dates

    hi everyone i have researched about this for days but nothing has come up. i would just like to know if this is possible.... i have an option that a user can select a date range by a start date and end date and it shall be displayed on the report as follows...

Part and Inventory Search

Back
Top