I haven’t used Access very much, so any help will be appreciated. I’ve inherited some data that I need to use. It’s in an Access database.
The structure of the database is something like this:
PersonNo Testtype TestScore
1 A 20
1 B 80
1 C 5
2 A 30
2 D 110
I want the data in the following format
PersonNo TestAScore …. TestDScore
1
2
Or one record for each individual.
I tried to write a query that had PersonNo as the first variable. The second variable should have been TestScoreA. I tried to build that column using the following function:
IIf([TESTSCORES]![TestType]=”A”,[TESTSCORES]![TestScore],””).
The error that I received said that I had a Datatype mismatch in a criteria expression. I’m afraid that I’ve made some fundamental error in how queries work.
