Hi Fredg:
This is one of the queries(loans):
SELECT Attendance.[#], Attendance.Fecha, Attendance.[Socio #],
Attendance.[Razon Visita], Attendance.User, Attendance.[Linea Credito],
Attendance.[Master Card], Attendance.[Prestamo Auto], Attendance.[Prestamo
Colateral], Attendance.[Prestamo Hipotecario], Attendance.[Prestamo
Personal], Attendance.VISA
FROM Attendance
WHERE (((Attendance.Fecha) Between [From Date] And [To Date]) AND
((Attendance.[Linea Credito])=True)) OR (((Attendance.[Master Card])=True))
OR (((Attendance.[Prestamo Auto])=True)) OR (((Attendance.[Prestamo
Colateral])=True)) OR (((Attendance.[Prestamo Hipotecario])=True)) OR
(((Attendance.[Prestamo Personal])=True)) OR (((Attendance.VISA)=True))
ORDER BY Attendance.Fecha;
This is the second one(services):
SELECT Attendance.[#], Attendance.Fecha, Attendance.[Socio #],
Attendance.[Razon Visita], Attendance.User, Attendance.[ATH Nueva],
Attendance.[Certificado de Ahorro], Attendance.[Christmas Club],
Attendance.[Cuenta Cheques Comercial], Attendance.[Cuenta Cheques Personal],
Attendance.[Vera Coop]
FROM Attendance
WHERE (((Attendance.Fecha) Between [From Date] And [To Date]) AND
((Attendance.[ATH Nueva])=True)) OR (((Attendance.[Certificado de
Ahorro])=True)) OR (((Attendance.[Christmas Club])=True)) OR
(((Attendance.[Cuenta Cheques Comercial])=True)) OR (((Attendance.[Cuenta
Cheques Personal])=True)) OR (((Attendance.[Vera Coop])=True))
ORDER BY Attendance.Fecha;
This is the third querry( it's a summary of both):
SELECT [Reportes Prestamos].Fecha, [Reportes Prestamos].[Socio #], [Reportes
Prestamos].User, [Reportes Servicios].[ATH Nueva], [Reportes
Servicios].[Certificado de Ahorro], [Reportes Servicios].[Christmas Club],
[Reportes Servicios].[Cuenta Cheques Comercial], [Reportes Servicios].[Cuenta
Cheques Personal], [Reportes Prestamos].[Linea Credito], [Reportes
Prestamos].[Master Card], [Reportes Prestamos].[Prestamo Auto], [Reportes
Prestamos].[Prestamo Colateral], [Reportes Prestamos].[Prestamo Hipotecario],
[Reportes Prestamos].[Prestamo Personal], [Reportes Servicios].[Vera Coop],
[Reportes Prestamos].VISA, [Reportes Prestamos].[#]
FROM [Reportes Prestamos], [Reportes Servicios]
WHERE ((([Reportes Prestamos].Fecha) Between [From Date] And [To Date]));
Thanks Fredg, hope this help you in helping me
fredg said:
I had 2 queries I need to combine. One has information about services and
the other one has info about loans. I had [Date], [ID] and several check
boxes on each query (check boxes are different on each query)
What I want to do is combine both in order to display the [date], [id] and
all the check boxes. Notice, one ID could have check boxes in one of the
queries, both or none.
Think I will need to use relationship but no matter if I do it with the [id]
or [date], the query didn't show all the items
Can any of you please Help me!
The crystal ball is down right now.
Can't help unless you post the entire query SQL.
Note:
Date is a reserved Access/VBA/Jet word and should not be used as a
field name.
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:
109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'
Try changing the field named date to another name.
Then try your query again. Perhaps that's all you need do.
