Selasa, 21 Mei 2019

[MS_AccessPros] help with query

 

I have a query with participants name and up to 4 special diets for each: ID, diet1, diet2, diet3, diet4.

I need to count the total numbers for each diet. I think I would need to use TRANSFORM COUNT(diet1) etc, but since it is 4 separate columns I am not sure how to do this  and how to GROUP it so that I get only one column:

eg :NOSUGAR total nn

NOSALT total nn

the total would be  based on all 4 columns combined.


All help is greatly appreciated.


Sarah



__._,_.___

Posted by: sarahk@schemesoftware.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (17)

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.


SPONSORED LINKS
.

__,_._,___

Tidak ada komentar:

Posting Komentar