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.