Search results

Thank you plog ^.^

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...

Thanks for your helping. ^.^ And for your advising, I think table name 'Report' is not good like you but I know when it's too late. If I change it, I must fix nearly all of my code however I will remember and don't do it again.

This is my code ^.^

I use Access 2007 When I run this code, No Error Message it just open blank form. 1. I'm sure there have matching Record. 2. I already check my spelling 3. get_date is fieldName and gDate is textBoxName When I try to open Form by use another field (is not dateField) with this code v...

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

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