Please help combine these 2 queries into 1 1

[Webkins]

Hello, I am trying to combine the two queries below into one, actually I need this for each day of the week. Each query works fine on its own, but now I need them combined. I am using MSAccess 2003 and Windows XP. Is this possible at all ? Any advice, suggestions or examples would be greatly appreciated. Thank you.

SELECT qry_autorizacion_sum.Tecnician, qry_autorizacion_sum.Day, (qry_autorizacion_sum.Hours) as Saturday
FROM qry_autorizacion_sum
WHERE (((qry_autorizacion_sum.Tecnician)="juan rodriguez") AND ((qry_autorizacion_sum.Day)="saturday"));

SELECT qry_autorizacion_sum.Tecnician, qry_autorizacion_sum.Day, (qry_autorizacion_sum.Hours) as Monday
FROM qry_autorizacion_sum
WHERE (((qry_autorizacion_sum.Tecnician)="juan rodriguez") AND ((qry_autorizacion_sum.Day)="Monday"));

 

[dhookom]

How would you want to combine them? Do you want a column for each day?

If you want a column for each day, use a crosstab query based on qry_autorizacion_sum.

Duane
Hook'D on Access
MS Access MVP

 

[Webkins]

Yes, 1 query and 7 columns, one for each day of the week.

 

[dhookom]

Were you able to create this in a crosstab query or do you need additional assistance?

Duane
Hook'D on Access
MS Access MVP