By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,105 Members | 1,048 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,105 IT Pros & Developers. It's quick & easy.

From the previous question - Search the records by groups based on identical field value

P: n/a
Hello Everybody
With regard to the same query, I have another problem and I just dont
understand where am I going wrong and I m not getting the result I
need.
Following the suggestion given by Tom van and everybody else, I solved
my previous problem and I also converted the Diff_VisitDate into Months
like this :
GroupId VisitDate Diff_VisitDate(in months)
1 10/19/1993 0
1 11/24/1998 60
2 10/18/1993 0
2 10/29/1997 48
3 10/21/1993 0
3 11/03/1998 60
4 10/25/1993 0
4 10/29/1994 12
4 04/29/1999 66
5 04/26/1994 0
5 03/29/1999 60
5 03/28/2000 72

6 09/06/2001 0
7 09/07/1995 0
7 09/12/2001 72

Now I am trying to create a query, which gives me the GroupId that
does/does not have a particular value.
But when I create the query, it runs for each and every record, but i
just want the result for the set of each GroupId.
Say if I want to find the list of GroupId that does not have 60
(Diff_VisitDate), the result should be
GroupId
2
4
6
7

Is it possible to do this ? Can somebody tell me how to group the
records in the query by GroupId.

Thanks again in advance for all your help. Kindly excuse me if this is
a silly question.

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.