Search results

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

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