Search results

  1. C

    Group by month and year

    I try this code SELECT Format(ReportTbl.lot_date,"mm-yyyy") AS Lot, Round(Avg(ReportTbl.avg_dat),2) AS DataAvg, Round(Avg(ReportTbl.avg_len),2) AS LenAvg, Round(Avg(ReportTbl.avg_in),2) AS InAvg, Round(Avg(ReportTbl.avg_out),2) AS OutAvg, Round(Avg(ReportTbl.avg_thi),2) AS ThiAvg...
  2. C

    Open form with where condition

    I try this code and it's not working no record found Private Sub openForm_but_Click() Dim whr As String whr = "get_date = #" & Me.gDate & "#" DoCmd.OpenForm "searchResult_form", acNormal, "", whr, acFormPropertySettings, acDialog End Sub
  3. C

    Hello

    Hello every body ^.^ I come from Thailand I have just start with MS Access I know not much, but I will try.
Back
Top Bottom