I have 2 tables: Hours, that contains one field and has records for every hour (9:00, 10:00, 11:00, ...). The second table, table2, is as follows: ID, date hour, 1, 2, 3, 4, 5.
I have a query that looks like this: select table2.*, hours.hour from hours left join on hours.hour = table2.hour;
This gives me a spreadsheetlike result datasheet with all the hours on the first column(used as row headers) and 1,2,3,4 as columns headers.
My problem is when I put a filter on this query to get this datasheet for a specific date: I loose the first column, where all the hours are.
Is there a way to have that query display the "agenda like" datasheet even with a filter applied?
thanks for all your help/comments
I have a query that looks like this: select table2.*, hours.hour from hours left join on hours.hour = table2.hour;
This gives me a spreadsheetlike result datasheet with all the hours on the first column(used as row headers) and 1,2,3,4 as columns headers.
My problem is when I put a filter on this query to get this datasheet for a specific date: I loose the first column, where all the hours are.
Is there a way to have that query display the "agenda like" datasheet even with a filter applied?
thanks for all your help/comments
