Search results

OK the results are not returning the correct median values. I test some parameters using Excel and doing the analysis manually and it doesn't work for sure. for referral to treatment January 2011 should be 61 and it is 18 according to the report

initial code does work my friend. all sorted now :) have problems with median average reports outputtting incorrect results though! see link

i have somethung crude but it works me.ListBoxname = Is Null in the got focus property

My bad Multi select is set to none

I don't want to have users select multiple items in a list box. Only a single item.

I have eight list boxes on a form. When you click on an item in a list the form populates with corresponding data. I want the list box item to 'unselect' if I click from one list box to another Here is what I have tried Private Sub ListBoxName_LostFocus() Me.OtherListBoxName = Null I...

Just what I am used to doing when running reports. When I create reports I have grown up getting used to using queries as the source. Am I rioght in thinking that technically the whole thing could be built via VBA coding?

ahah - i think its working. What a guru you are sir

I tried that before and it didn't work!!- Hmmm- I have a missing operator error message now - error 3075 missing operator in query expression. Strange as when i run the query in SQL format it works fine Set rs = CurrentDb.OpenRecordset("SELECT [ReferralToTreatment] " & _...

I think the code is saying it doesn't know what table or fieldname to look at (in lamens terms)

OK Now have 'syntax error in FROM clause? Set rs = CurrentDb.OpenRecordset("SELECT [" & fldname & "] " & _ "FROM [" & tname & "] " & _ "WHERE [" & fldname & "] IS NOT NULL " & _ "AND...

I used your code vbanet for the parameters: Set ssMedian = MedianDB.OpenRecordset("SELECT [" & fldname & "] " & _ "FROM [" & tName & "] " & _ "WHERE [" & fldname & "] IS NOT NULL " & _ "AND (Date_Referred BETWEEN #" & [Forms]![frmReport]![startdate] & "# AND #" & _...

Right - that working - just need to add parameters in select statement... here we go.....

i get an error message 'the expression you entered as a query parameter oroduced this error [sqlstr]

Am I calling that in the query window?

I think I migth start from scratch and use base the record select on vbainet code

I need to get a better understanding of the recordset function. I don't understand what the code is doing

ah yes x = ssMedian(fldName)

Morning - hope you had a good weekend. Picked this up again and have tried Function Median(tName As String, fldName As String) As Single Dim MedianDB As DAO.Database Dim ssMedian As DAO.Recordset Dim RCount As Integer, i As Integer, x As Double, y As Double, _ OffSet As Integer Set MedianDB...

ah right - the median function applies to just one report so I am happy for that to change yes. sorry