So: I have a Report (rpt_ServiceRequirement) which lists clients (from my Table tbl_Clients) & some variables re: those clients, which I've built into tbl_Clients as a Lookup & Relationship (where I've entered the values myself; there will only ever be a choice between a few static options).
My question is: can I have my Report detail the occurrence of these variables, across my client-base?
Like, "56% of Clients said x" & "44% of Clients said y" & maybe even report it in a pie-chart (or something)?
I also have several Yes/No Fields, & would like to do %s based on those & have them appear in my Reports (like, 32% of Clients said "Yes", under RequireAdditionalServices, based on the # of Clients who did).
I apologize if these are simple questions that have already been answered here; I'm trying to learn more about Access, & am not always sure how to explain them enough to search for existing solutions that have already been posted.
I'd appreciate any guidance you could provide.
My question is: can I have my Report detail the occurrence of these variables, across my client-base?
Like, "56% of Clients said x" & "44% of Clients said y" & maybe even report it in a pie-chart (or something)?
I also have several Yes/No Fields, & would like to do %s based on those & have them appear in my Reports (like, 32% of Clients said "Yes", under RequireAdditionalServices, based on the # of Clients who did).
I apologize if these are simple questions that have already been answered here; I'm trying to learn more about Access, & am not always sure how to explain them enough to search for existing solutions that have already been posted.
I'd appreciate any guidance you could provide.
