Hello,
So I am trying to build a little program in Microsoft access and i have done a simple crosstab where i have for row headings some usernames, dates as column headings and as values i have hours.
The idea is that in the main table ( tbl_activitate) for those usernames in each day i have more hours values written. I want to somehow do a sum of MaxIF - MinIF in this crosstab by value if it is on the column heading date in table.
I have done this in an excel, but i don't know how to do it in access.
Users - the rowheading of usernames;
Data confirmare - the column headings with dates;
Ora confirmare - the values ( hours );
Sorry and thanks in advance, but i'm new to Acces and I am self-taught. I want to develop mysfel and I also don't know how to write a code in SQL.