Search results

Thanks Paul. I saw the reply on other site :-) I have posted new question there. If you could please answer it , that will really help. Thanks a lot!

I am a newbie and need some help. I have a form A which opens a new form Form B on submitting a button. The Form B has many buttons on it. Each one opes different form. I want to move one of the button on form B to form A. and have the same functionality as it is having it on form B. I have...

Hi David, Yes that was perfect!! Thanks a lot!! I had never thought writing my Oracle working query in Access will be that different!! Thanks a lot!! Subbu.

David, I am trying to break my query into two to take care of nested function. But not able to figure out how should i be doing it. Can you please help me?

David, What you interpreted looks logical if the two columns have got unique combinations. But in my case there can be pairs like say ID Name 1 aa 1 aa 1 aa 2 bb 2 cc 3 dd 4 rr 4 tt 4 ss In this...

David, Thanks for your reply. This query works fine in oracle. In access it is giving me error on the first line where i have count(distinct(name). Looks like Access can not take nested functions. I am new to access.

I want to write a query as : select ID, count(distinct(name)) from user where id is not null group by ID having count(distinct(name))>1 but looks like this query fails in access due to multiple functions. Can someone help me how should i be writing this. NOte. Id is not a...