Pivot Charts in Access 2003
lancekmc | Posted 4:26am 5. March 2009 Server Time |
I have charts ploted but i cant sort my dates in ascending order they keep getting mixed up yet i have sorted the source table and the query any ideas as to how i can do this? |
lancekmc | Posted 4:32am 5. March 2009 Server Time |
i have a table from which i have created a query to pick out the info i need and with the max date i.e most recent date against the particular record, and am trying to do this from an SQL statement in VBA looks something like this
strCriteria = "SELECT * FROM qryMaxLabDate_Result WHERE qryMaxLabDate_Result.clinic_code= " _
& "'" & [Forms]![frmMainForm]![txtSelectClinic] & "'" & " AND " _
& " qryMaxLabDate_Result.chart_number='" & [Forms]![frmMainForm]![lstSelectPatient] & ""
is that how to refere to fields in the query and how to i get to define the max date to be picked.
Reply to Post Pivot Charts in Access 2003
|
|
|
