super_si

I have 3 field

playerForename,playerSurname,cardtype.

I want to inpu the SQL so it groups together.

The players name, and a number of the yellows and red cards.

Unfortunatly my SQL knowledge is 0!!

Im using access for the queries but im not sure how complex i can make it.

i want the query to show

Player forename, Player surname, total reds, total yellow then i use GUI in VB to display.

Thanks

Si

DazV

Why not just
forename, surname, total_yellow, total_red

Then select * and sort them on surname ?

bashful

Super,

I'd suggest making two queries, one with F&S and reds, the other with F&S and yellows, then joining them on F&S. However, your database will blow a fuse if you have two different players with the same name - if I was your lecturer I'd tell you to look at your data structure.

Is ScoobyNet going to get partial credit for your degree?

super_si

hehehehe

Cheers mate.

Instead worrying so much.

ive sat down, read my database book and ive learnt quite a bit.

making rapid progress quite impressed with my self.

Who knows how to write an install package