Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to make crosstab query update in report
Hi, Thanks alot for your help, I have done it according to your point and got success. Just last question. Is there any posibility that I could add columns dynamically. Rightnow my report shows columns from 1 - 12, however I have data till 1 - 6 and 7-12 cols are unneccessary. What I want...- BenSaeed
- Post #7
- Forum: Microsoft: Access Forms
-
How to make crosstab query update in report
Please forgive me if I could not get you clearly, as I am new in using Access. First my look at my query TRANSFORM Workersdetail.workername AS CountOfedate SELECT Workersdetail.[workerhourenter], Count(Workersdetail.[edate]) AS [Total Of edate] FROM Workersdetail GROUP BY...- BenSaeed
- Post #5
- Forum: Microsoft: Access Forms
-
How to make crosstab query update in report
Thank you for the reply, Let assume my pivot stand on one field only, like this -> PIVOT site For your perfect understanding my crosstab query result mentioned hereunder. Columns RJ...........PAL.........Route..........(These are the name of site) Rows Anthony Ben Christian...- BenSaeed
- Post #3
- Forum: Microsoft: Access Forms
-
How to make crosstab query update in report
Hello, I made a report with following crosstab query. TRANSFORM Workersdetail.workername AS CountOfedate SELECT Workersdetail.[attendance], Count(Workersdetail.[edate]) AS [Total Of edate] FROM Workersdetail GROUP BY Workersdetail.[Workername], Workersdetail.[attendance]...- BenSaeed
- Thread
- Replies: 7
- Forum: Microsoft: Access Forms
