Hi,
Frustratingly simple issue, or so I thought.
I have a table with record akin to:
user date page_visited
107107 20170701 home
107107 20170701 account
107107 20170701 help
124865 20170701 home
124865 20170701 account
107107 20170702 home
107107 20170702 game
What I am trying to create is a report in the format:
User date home account help game
107107 20170701 True True True
20170702 True True
124865 20170701 True True
There are many more users and many more types of pages visited, so it needs to be a flexible and expandable solution.
I don't mind if this achieved within the design of the report or with a query, even making a new table is fine.
Any help much appreciated
James
__._,_.___
Posted by: mrmarmite_2000@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar