Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Datatype mismatch (Access 2000)

    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.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Datatype mismatch (Access 2000)

    Try a crosstab query, and let the wizard guide you thru it.
    HTH
    Pat

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Datatype mismatch (Access 2000)

    Worked great. Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •