RonnieDobbs
MIS
Hello,
I have imported an excel spreadsheet into Access and I am looking to create reports based on this one sheet, (one table in Access)
Data is results from a survey. So basically people are asked who much they know about something, 1 is expert, 2 average, 3 need help. I want to get results based on what Branch they are reporting from, and what instances they marked a 3 for.
Example row:
BSONUM Name Med Supp MMA PDP LTC
1111 Steve 1 3 2 3
I have started with a parameter query of:
SELECT [BSM GS].BSONUM, [BSM GS].Name, [BSM GS].MedSup, [BSM GS].MMA, [BSM GS].PDP, [BSM GS].LTC
FROM [BSM GS]
WHERE ((([BSM GS].BSONUM)=[enter bso #]))...
How do i query to only get # 3 respnses?
thanks,
Ron
I have imported an excel spreadsheet into Access and I am looking to create reports based on this one sheet, (one table in Access)
Data is results from a survey. So basically people are asked who much they know about something, 1 is expert, 2 average, 3 need help. I want to get results based on what Branch they are reporting from, and what instances they marked a 3 for.
Example row:
BSONUM Name Med Supp MMA PDP LTC
1111 Steve 1 3 2 3
I have started with a parameter query of:
SELECT [BSM GS].BSONUM, [BSM GS].Name, [BSM GS].MedSup, [BSM GS].MMA, [BSM GS].PDP, [BSM GS].LTC
FROM [BSM GS]
WHERE ((([BSM GS].BSONUM)=[enter bso #]))...
How do i query to only get # 3 respnses?
thanks,
Ron