Basically needing a bit of help with MS Access, and a few forms im doing.
Ive made a form, which is now linked with an imported MS SQL database/table.
I need to display a result in a label. I've already done this (a bit of it) to display in a drop down box, but dont think I can in a label(need to though, or atleast have the default value showing in the drop down box, rather than having to click it first.
The queries I need to perform in one go are:
A) SELECT count(*) AS TOTAL FROM questionnaire_samplegroup3;
B) SELECT count(*) AS YES FROM questionnaire_samplegroup3 WHERE question1 = 'Yes';
C) SELECT count(*) AS NO FROM questionnaire_samplegroup3 WHERE question1 = 'No';
So these need to be like in the same row source? dont think that will work, and then basically perform the calculations
so that I can work on the percentage of the results of each of these queries.
A) Changes all the time, well, they all do so cant just work out the % once, it need to auto calculate as above.
I thought of something like this:
SELECT SUM(YES / TOTAL * 1000), count(*) AS TOTAL, (SELECT count(*) AS YES FROM questionnaire_samplegroup3 WHERE question1 = 'Yes') FROM questionnaire_samplegroup3;
Here its not apreciating the subquery..
Who would think i've got a degree in this stuff
It's been ages since ive done it, even longer since I used access in this depth, and even longer since i slept. Helpen moi