Hi thanks for everything,

I figured it out.

The problem was the tblEvents table have duplicate cardID which should be okay but I thought it was wrong because in the actual tblCards...

The first query:

SELECT distinct dbo.tblUsers.strUserName, dbo.tblCards.dtePrintDate AS PrintDate, dbo.tblCardFormatTypes.strName AS CardType, dbo.tblPersons.CSU_ID AS ID_NUMBER, dbo.tblPersons.LAST_NAME, dbo.tblPersons.FIRST_NAME

FROM dbo.tblUsers

INNER JOIN dbo.tblEvents ON dbo.tblUsers.ID = dbo.tblEvents.UserID...

Thanks for the reply here are some details:

I have these tables with some columns

tblEvents:

UserId

CardID

EventType

tblUser:

ID

UserName

tblCards:

ID

dtePrintDate

intIssuedBY (same as UserID)

...(many more)

I want to count in the tblEvents how many cards each user has...

thanks for the replies,

notepad is just an example. but even if its just a batch file that do some task, it doesnt seem to run it.

it does appear on the...