Search results

Hi Bob, Still having trouble im afraid, here is the SQL from the query i have: SELECT Register.Scout, Register.Date, Register.Activity, Count(Register.Scout) AS [Counter] FROM Scout INNER JOIN Register ON Scout.ID = Register.Scout.Value GROUP BY Register.Date, Register.Activity...

Hi Bob, Sorry but im not sure where to put the code. when it comes to programming i'm usless. :) cheers

hi all, the report is based upon a table which includes a mutiselect lookup of another table (the names). the listbox and textbox are both in the detail section of the report. should have mentoned this earlier perhaps. cheers

the control source is empty. cheers

well spotted, now i have a runtime error "you cannot assign a value to this object" cheers

Sorry vbaInet i have added the code to the on open event and i get an error, the code i have is: Option Compare Database Private Sub Report_Open(Cancel As Integer) =Me.Text62=Scout.ItemsSelected.Count End Sub Thanks for all your help so far and aplolgoies for being a pain.

hi again vbaInet, I have changed it to =[Scout].[ItemsSelected].[Count], (the square brackets were added automatically), however the result it now displays is 0. i am using Access 2010 if this helps cheers

Hi VbaInet, thank-you for the reply but is this a line of vba code? if so i have no idea how/where to put this. any help is much appreciated cheers

Hi everyone, I have a list box of names in a table, on the report i wish to count the number of names selected in from the list box. for instance i have 20 names to choose from, if i select 5 of them, i would like a text box on my report to show 5. i have tried using =count(listboxfield) in...

Hi, can anyone explain why i am getting duplicate date from the following sql? SELECT [Scout Details].Scout, Term.Term, IIf([Subs Paid]![Date] Between [Term]![Start] And [Term]![End],"Paid","Owes") AS Status FROM [Subs Paid], Term, [Scout Details] WHERE (((Term.Term)>"3 - 2011")); Basically i...

Thanks Guus2005, I managed to compete my query using the following sql: SELECT Term.Term, Finances.Scout, Finances.Date, Finances.Description, Finances.[Received (In)], Finances.Notes FROM Term, Finances WHERE (((Finances.Date)>Term!Start And (Finances.Date)<Term!End) And...

Hi, i am a self tought novice to access. i have created a database for my scout troop and i am tying to filter a query between two dates. I have one table for school terms consisitng of 3 fields: the first field id the term name, second field the start date and the third field is the finish...