I have a table GUESTREGISTRATION
I need to prepare my MIS and request help in getting the following ouput
I need to filter only FRIDAYS for last years and get ouput like this
Date AMOUNT Date Amount Date Amount
Depending on number of Fridays in 2 years the number of Columns will increase !
How do i do this?