Hi Peter: It’s been a while since I had to bother you, and I think this one might just be me being stupid!
But I have a long list of music ‘plays’ on that page I’ve linked to, and I’d like to summarise/aggregate them (so: Average Plays Per Day X, Top Genre: Y …and so on).
I’d have no trouble creating a view with plain SQL on the backend with the requisite grouping, sorting and aggregating… but can you do it in WP Data Access?
It occurs to me that though I’ve used WPDA for more than a long time, I’ve only ever used it to create and populate and display tables.
Sorry if it’s a dumb question.
The page I need help with: [log in to see the link]
- The topic ‘Can I use WP Data Access to create a view?’ is closed to new replies.