Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Groupby not allowed in a subquery (report footer section =rowcount(*))
I find the answer by myself, forget to update sorry- techtown
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Groupby not allowed in a subquery (report footer section =rowcount(*))
SELECT [ASOCIADOS DENSO].ID AS [NUMERO DE EMPLEADO], (SELECT COUNT([ID])FROM[FALTAS GENERALES] WHERE [ASOCIADOS DENSO].[ID]=[FALTAS GENERALES].[ID] and [FALTAS GENERALES].[FECHA]>(NOW()-365) and ( [faltas generales].[incon]=" 150 FALTA INJUSTIFICADA" or [faltas generales].[incon]=" 180 FALTA...- techtown
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
