List:General Discussion« Previous MessageNext Message »
From:Richard Reina Date:February 23 2006 4:48pm
Subject:query help?
View as plain text  
I am a novice when it come to queries such as this and  was hoping someone could help me
write a query that tells me how many records have the same ID and vendor number.
 
 |ID     | vendor_no  | date            |
 |2354  | 578              | "2005-12-23"|
 |2355  | 334              | "2005-12-24"|
 |2356  | 339              | "2005-12-26"|
 |2357  | 339              | "2005-12-26"|
 |2358  | 339              | "2005-12-26"|
 |2359  | 445              | "2005-12-26"|
 |2354  | 522              | "2005-12-27"|
 |2355  | 522              | "2005-12-27"|
 
 Would I use select count? Any help would be greatly appreciated.
 


A people that values its privileges above its principles soon loses both.
 -Dwight D. Eisenhower.
Thread
query help?Richard Reina23 Feb
  • Re: query help?cnelson23 Feb
    • Re: query help?Richard Reina23 Feb
      • Re: query help?SGreen23 Feb
        • Re: query help?Richard Reina23 Feb
  • RE: query help?Andy Eastham23 Feb