Viewing 4 posts - 1 through 4 (of 4 total)
Why not just add the Attended Field to the grouping and remove it from the criteria
Should give you something like -
Student ID Date Attended Count
---------- ----- --------- ------
123 16 May...
May 16, 2005 at 10:45 pm
you should start by normalising:
have a file table and a product table, then have a join table
file
----
file 1
file 2
file 3
Product
-------
A
F
W
Z
G
File_Product table
File Product
--- -------
file 1 A
file 1 F
...
file 2 A
file...
February 28, 2005 at 6:58 pm
David C, I am an Access developer first, and WITH TIES is automatic for it. I paid close attention when I found out that SQL Server was different.
David B>
February 1, 2005 at 2:47 pm
"The primary drawback to it, is in the event of a tie in sales, only one person's name is going to come up."
You can use WITH TIES to allow for...
January 31, 2005 at 10:10 pm
Viewing 4 posts - 1 through 4 (of 4 total)