Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    Melbourne
    Posts
    92

    Unanswered: Some help - easy for u gurus

    I have a tbl called FishDetails where I enter details on the capture of fish for the surveys that I conduct. On this form I have a combo box that uses a look up table called TblZones to select which part of the river the fish was caught e.g zone1, zone2 etc

    I created a query that joins TblAnglers and tblFishDetails to show who caught what. My problem is that when I create a pivot table or any reports the Zone location is displayed as the ZoneID not the Zone location as e.g Zone1, but as 1 instead.

    If I email my DB, can some have look and see what Im doing wrong.

  2. #2
    Join Date
    Feb 2003
    Location
    Auckland, NZ
    Posts
    150

    Lightbulb

    You need to create a query that joins the tblFishDetails wit tblZones on ZoneID. Select the Zone Description in the query. Base your report on the query created.

    Machado

  3. #3
    Join Date
    Nov 2002
    Location
    Melbourne
    Posts
    92
    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
  •