Recent content by Quantarama

Hi all, I was wondering if there was any way to count the number of occurences of any values in SQL ? Example : In a customer database, counting the number of times the same d.o.b occurs and returning it in a new collumn. This is working : SELECT [DOB] ,COUNT([DOB]) AS D However I want it...

Hi everyone, I had a question regarding changing the criteria in a query depending upon the option selected in a combo box(which lives in a form) So basically, can we do a multiple IIf then function in the criteria row of a Query and what would be the syntax be like ? At the moment I am...

Many Thanks John, that was exactly what I was after

Hi all, I have a question regarding the combo box : As per normal there will be a few drop downs to select from. And then there will be a click button, which will then pull up a corresponding query depending upon which option they selct in the combo box. Basically the idea is depending upon...

Access newbie here.. what a relief that I found this forum. Am hoping to learn a lot from here